SQL Anywhere® Server - SQL Reference
SQL Data Types
Data type conversions
Conversion between character sets
SQL Anywhere automatically applies character set conversion when evaluating expressions. Generally, if an operation requires interaction between a CHAR and an NCHAR type, the CHAR type will be converted to NCHAR.
In some cases, such as during an assignment of a result value, an NCHAR type must be converted to CHAR. In this case, conversion errors can occur if the NCHAR string contains characters that cannot be represented in the CHAR type. When a conversion error occurs, the character that cannot be represented is converted to the substitution character for the CHAR character set. For single-byte character sets, this is usually hex 1A.