Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateInternal functions → ASCII_CHAR()
Firebird Home Firebird Home Prev: ACOS()Firebird Documentation IndexUp: Internal functionsNext: ASCII_VAL()

ASCII_CHAR()

Tip

Find a more recent version at Firebird 5.0 Language Reference: 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.

Prev: ACOS()Firebird Documentation IndexUp: Internal functionsNext: ASCII_VAL()
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateInternal functions → ASCII_CHAR()