Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0411


  • The first 256 Unicode characters (0, 255) correspond to the ASCII character set.
  • Input values for the CHAR function should be of integer type. Decimal type column data can be used as input. However, if the data contains digits to the right of the decimal point, the CHAR function returns a missing value.
  • If the function cannot evaluate the numeric data, a null value is returned.

D s

Column reference example:

D code

derive value:CHAR(MyCharIndex)


Unicode index value of the character to generate or match.

  • The Unicode character set contains up 1up 1,114,112 characters. Most uses rely on the first 10,000 characters. 
  • Value must be less than end_index.

D s


Required?Data TypeExample Value
YesInteger (non-negative)65

D s

Example - char and unicode functions