Entrypoint collatebr not compatible with UTF-8 - if needed please ask
Input CSTRING(32760) String in which special characters are to be converted Output CSTRING(32760) changed String
Changes intended "umlauts" for given indications á, â, ã, à, ä, å, Á, Â, Ã, À, Ä, Å => A é, ê, è, ë, É, Ê, È, Ë => E í, î, ì, ï, Í, Î, Ì, Ï => I ó, ô, õ, ò, ö, Ó, Ô, Õ, Ò, Ö => O ú, û, ù, ü,Ú, Û, Ù, Ü => U ç, Ç => C ñ, Ñ => N ý, ÿ, Ý => Y
TestSQL SELECT 'AAAAAAAAAAAA' AS ISCORRECT, F_COLLATEBR('áâãàäåÁÂÃÀÄÅ') FROM RDB$DATABASE; SELECT 'EEEEEEEE' AS ISCORRECT, F_COLLATEBR('éêèëÉÊÈË') FROM RDB$DATABASE; SELECT 'IIIIIIII' AS ISCORRECT, F_COLLATEBR('íîìïÍÎÌÏ') FROM RDB$DATABASE; SELECT 'OOOOOOOOOO' AS ISCORRECT, F_COLLATEBR('óôõòöÓÔÕÒÖ') FROM RDB$DATABASE; SELECT 'UUUUUUUU' AS ISCORRECT, F_COLLATEBR('úûùüÚÛÙÜ') FROM RDB$DATABASE; SELECT 'CC' AS ISCORRECT, F_COLLATEBR('çÇ') FROM RDB$DATABASE; SELECT 'NN' AS ISCORRECT, F_COLLATEBR('ñÑ') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_COLLATEBR(NULL) FROM RDB$DATABASE;