meta data for this page
  •  

F_CONVERTFROMBASE

compatible to FreeUDFLibC

Entrypoint convertfrombase

Inputs/Outputs

   Input     CSTRING(32)      number from anyone number-system as string
             INTEGER          Basis of the number which can be converted (for example 2 for binary-system)
             CSTRING(8)       all numbers, which are valid in the number-system as string (e.g. ‘01234567' 
                              for oktal-system).
   Output    INTEGER          integer in decimal system

Syntax

   TestSQL
   SELECT 3 AS ISCORRECT, F_CONVERTFROMBASE('11', 2, '01') FROM RDB$DATABASE;
   SELECT 9 AS ISCORRECT, F_CONVERTFROMBASE('11', 8, '01234567') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_CONVERTFROMBASE(NUll, NULL, NULL) FROM RDB$DATABASE;