<< F_PROPERCASE U_PROPERCASE | IBExpert UDF Functions | F_ORD U_ORD >>

F_CHARACTER

substitutable with ASCII_CHAR

• compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP

F_CHR

• compatibility to GrUDF

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP compatibility to GrUDF input/output-compatibility to rFunc (CHR)

U_CHR

• function from adhoc
• Compatible with UTF-8
• Input INTEGER ASCII-Code
• Output VARCHAR(2) Character of ASCII-Codes

U_CHR raises exception for UTF8

Example

 SELECT 'B' AS ISCORRECT, F_CHARACTER(66) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_CHARACTER
 ========= ===========
 B         B

Example

 SELECT NULL AS ISCORRECT, F_CHARACTER(NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_CHARACTER
 ========= ===========
 B         B
 <null>    <null>                  

back to top of page
<< F_PROPERCASE U_PROPERCASE | IBExpert UDF Functions | F_ORD U_ORD >>