SQL Anywhere Server character set conversion causes all SQL statements to be converted to the database character set prior to parsing and execution. A side-effect of this conversion is that any characters in the SQL statement that cannot be converted to the database character set are converted to a substitution character. A SQL statement with an arbitrary Unicode character can be executed in one of the following ways:
Use UTF-8 as the database character set
Use the UNISTR function to specify the Unicode character values
Use a host variable to specify the Unicode character values