meta data for this page
  •  

F_KEYUP

function from adhoc

Entrypoint keyup not compatible with UTF-8 - if needed please ask

Inputs/Outputs

 Input    CSTRING(32760)      String to prepaired
          SMALLINT	        length of output-string
 Output   CSTRING(32760)      prepaired string

Syntax

 Prepares a string with
 - all to upper
 - uses only alphanumeric characters incl. umlaut
 - changes intended "umlauts" for given indications
      Á, Â, Ã, À, Ä, Å      => A
      É, Ê, È, Ë                 => E
      Í, Î, Ì, Ï                     => I
      Ó, Ô, Õ, Ò, Ö         => O
      Ú, Û, Ù, Ü               => U
      Ç                             => C
      Æ                            => AE
      Ø                            => OE
      ß                             => SS
      Đ                            => D
      Ñ                            => N
      Ý                            => Y
 - truncate string to given length
 TestSQL
 SELECT '7A 5E 5I 6O 5U 2C 2AE 2OE 4S 2D 2N 2Y 1234567' AS ISCORRECT, 
 F_KEYUP('AáâãàäåEéêèëIíîìïOóôõòöUúûùüCçAEæOEøSSßDd.NñYý1234567890', 55) FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT, F_KEYUP(NULL, NULL) FROM RDB$DATABASE;