meta data for this page
F_COLLATEBR
compatibility to GrUDF
Entrypoint collatebr not compatible with UTF-8 - if needed please ask
Inputs/Outputs
Input CSTRING(32760) String in which special characters are to be converted Output CSTRING(32760) changed String
Syntax
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;