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;