CHAR()

CHAR() — Returns a string with a single UTF-8 character associated with the specified character code.

Synopsis

CHAR( integer )

Description

The CHAR() function returns a string containing a single UTF-8 character that matches the specified UNICODE character code. One use of the CHAR() function is to insert non-printing and other hard to enter characters into string expressions.

Example

The following example uses CHAR() to add a copyright symbol into a VARCHAR field.

UPDATE book SET copyright_notice= CHAR(169) || CAST(? AS VARCHAR) 
       WHERE isbn=?;