8.3.1. ASCII_CHAR()

Available in

DSQL, PSQL

Possible name conflict

YES → Read details

Syntax

  1. ASCII_CHAR (code)
Table 123. ASCII_CHAR Function Parameter
ParameterDescription

code

An integer within the range from 0 to 255

Result type

CHAR(1) CHARACTER SET NONE

Description

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

  • 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.