meta data for this page
  •  

F_UPPER, F_ANSILOWERCASE

function from adhoc

compatibility to FreeUDFLib AvERP, GrUDF

Entrypoint upper not compatible with UTF-8 - use U_UPPER

U_UPPER

function from adhoc

Entrypoint u_upper compatible with UTF-8

Inputs/Outputs

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

Syntax

 In FireBird 2.0 no longer necessary. Use UPPER(..) All umlaut are handled correct.
 TestSQL
 SELECT 'SCHÖNER TAG' AS ISCORRECT, UPPER('Schöner Tag'), F_UPPER('Schöner Tag') FROM RDB$DATABASE;
 SELECT 'SCHÖNER TAG' AS ISCORRECT, UPPER('Schöner Tag'), F_ANSIUPPERCASE('Schöner Tag') FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT, UPPER(NULL), F_UPPER(NULL) FROM RDB$DATABASE;