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