Entrypoint upper not compatible with UTF-8 - use U_UPPER
Entrypoint u_upper compatible with UTF-8
Input CSTRING(32760) String to convert Output CSTRING(32760) String with all characters as upper incl. umlaut
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;