FUNCTION `sp_bin2dec`( IN vstup char(32) ) RETURNS BIGINT;

  // convert binary format to decimal
  // example: 111 -> 7, 1000 -> 8
  // maximum is 11111111111111111111111111111111 -> 4294967295

BEGIN

  DECLARE charcount, nasobitel TINYINT;
  DECLARE vysledek BIGINT;
  
  SET vysledek = 0;
  SET charcount = STRLENGTH (vstup);
  SET nasobitel = 0;

  WHILE charcount > 0 DO
    SET vysledek = vysledek + sp_pow(2,nasobitel) * str2bigint(SUBSTRING(vstup FROM charcount FOR 1));
    SET charcount = charcount - 1;
    SET nasobitel = nasobitel + 1;
 
  END WHILE;

  RETURN vysledek;
END