meta data for this page
  •  

F_EQUALSTRING

compatibility to FreeUDFLib AvERP, GrUDF

input/output-compatibility to rFunc (CEQUAL)

Entrypoint equalstring compatible with UTF-8

Inputs/Outputs

    Input      CSTRING(8190)     String 1
               CSTRING(8190)     String 2
    Output     INTEGER           1 = is equal, 0 = is not equal

Syntax

   TestSQL
   SELECT 1 AS ISCORRECT, F_EQUALSTRING('Pauline ist im Urlaub', 'Pauline ist im Urlaub') 
   FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_EQUALSTRING('Pauline ist im Urlaub', 'Paul ist im Urlaub') 
   FROM RDB$DATABASE;
   In FireBird 2.0 WITH <null>-declaration the following example returns <null>, in all other 
   databases the NULL-string is identical to an empty string, therefore the following example returns 1.
   SELECT NULL AS ISCORRECT, F_EQUALSTRING(NULL, '') FROM RDB$DATABASE;