SQL Anywhere can perform character set conversion between character sets that represent the same characters, but at different positions in the character set or code page. There needs to be a degree of compatibility between the character sets for this to be possible. For example, character set conversion is possible between EUC-JIS and cp932 character sets, but not between EUC-JIS and cp1252.
SQL Anywhere implements character set conversion using the International Components for Unicode (ICU) open source library, developed and maintained by IBM.
For more information about using character set conversion to compare values that are in different data types, see Comparisons between data types.
Connection strings and character sets
SQL statements and character sets
Troubleshooting unexpected symbols when viewing data
International aspects of case sensitivity
Character set conversion and client APIs
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|