CHR
The CHR
function returns the character having the specified binary value in the database character set.
SQL syntax
CHR(n
)
Parameters
CHR
has the parameter:
Parameter | Description |
---|---|
|
The binary value in the database character set. The character having this binary value is returned. The result is of type |
Description
-
For single-byte character sets, if
n
>256, then TimesTen returns the binary value ofn
mod 256. -
For multibyte character sets,
n
must resolve to one code point. Invalid code points are not validated. If you specify an invalid code point, the result is indeterminate.
Examples
The following example is run on an ASCII-based system with the WE8ISO8859P1
character set.
Command> SELECT CHR(67)||CHR(65)||CHR(84) FROM dual; < CAT > 1 row found.