CHAR function

CHAR finds and returns a character in Unicode character map by the number. The number is between 1 and 255.



number indicates which character in the Unicode character map is to be returned.

Note: The Unicode character map is different from the Windows ANSI character map or the MAC character map, according to the user's client. You cannot refer to the client's character map unless you use a server-side formula calculation.

When number is of [128, 255], the returned characters might be different in HCL Connections Docs and IBM® Symphony® in various locales, because the character maps used in HCL Docs (browser) and Symphony® (client-side applications) are different.


=CHAR(82) returns R.

=CHAR(255) returns ÿ.