meta data for this page
  •  

F_LOWER, F_ANSILOWERCASE

function from adhoc

compatibility to FreeUDFLib AvERP, GrUDF

Entrypoint lower not compatible with UTF-8 - use U_LOWER

U_LOWER

function from adhoc

Entrypoint u_lower compatible with UTF-8

Inputs/Outputs

 Input       CSTRING(32760)      String to convert
 Output      CSTRING(32760)      String with all characters as lower incl. umlaut

Syntax

 In FireBird 2.0 no longer necessary. Use LOWER(..) All umlaut are handled correct.
 TestSQL
 SELECT 'schöner tag' AS ISCORRECT, F_LOWER('SchÖner TAG') FROM RDB$DATABASE;
 SELECT 'schöner tag' AS ISCORRECT, F_ANSILOWERCASE('SchÖner TAG') FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT,  F_LOWER(NULL) FROM RDB$DATABASE;