This section describes how to set up your computing environment so that character set issues are handled properly. If you set your locale environments properly, then you do not need to turn on character set translation between client and server.
Configuring your character set environment
Determine the default locale of each computing platform in your environment. The default locale is the character set and language of each computer. On Windows operating systems, the character set is the ANSI code page.
For how to find locale information, see “Determining locale information”.
Decide whether the locale settings are appropriate for your environment.
For more information, see “Understanding collations”.
If the default settings are inappropriate, decide on a character set, language, and database collation that match your data and avoid character set translation.
For more information, see “Avoiding character-set translation”.
Set locales on each of the machines in the environment to these values.
For more information, see “Setting locales”.
Create your database using the default collation. If the default collation does not match your needs, create a database using a named collation.
For more information, see “Creating a database with a named collation”.
When choosing the collation for your database, consider the following:
Choose a collation that uses a character set and sort order appropriate for the data in the database. It is often the case that there are several alternative collations that meet this requirement, including some that are OEM collations and some that are ANSI collations.
There is a performance cost, as well as extra complexity in system configuration, when you use character set translation. Choose a collation that avoids the need for character set translation.
You can avoid character set translation by using a collation sequence in the database that matches the character set in use on your client machine operating system. In the case of Windows operating systems on the client machine, choose the ANSI character set. Character set translation is enabled by default for Sybase IQ database servers that are version 12.7 or higher. You can turn off character set translation using the -ct- option.
For information, see “Avoiding character-set translation”.
