ASCII_CHAR()

<< ACOS() | FB 2.5 Language Reference | ASCII_VAL() >>
<< ACOS() | FB 2.1 Language Reference | ASCII_VAL() >>

ASCII_CHAR()

Available in: DSQL, PSQL

Added in: 2.1

Description

Returns the ASCII character corresponding to the number passed in the argument.

Result type: [VAR]CHAR(1) CHARACTER SET NONE

Syntax

 ASCII_CHAR (<code>)

 <code> ::= an integer in the range [0..255]

Important:

  • If the external function ASCII_CHAR is declared in your database, it will override the internal function. To make the internal function available, DROP or ALTER the external function (UDF).
  • If you are used to the behaviour of the ASCII_CHAR UDF, which returns an empty string if the argument is 0, please notice that the internal function correctly returns a character with ASCII code 0 here.

back to top of page
<< ACOS() | FB 2.5 Language Reference | ASCII_VAL() >>
<< ACOS() | FB 2.1 Language Reference | ASCII_VAL() >>