Sybase 12.4.2 International language and character set tasks, Finding the default collation, 344

International language and character set tasks

International language and character set tasks

This section groups together the tasks associated with international language and character set issues.

Finding the default collation

If you do not explicitly specify a collation when creating a database, a default collation is used. For IQ databases, the default collation is always

ISO_BINENG.

Configuring your character set environment

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.

❖To configure your character set environment:

1Determine 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” on page 345.

2Decide whether the locale settings are appropriate for your environment. For more information, see “Understanding collations” on page 328.

3If the default settings are inappropriate, decide on a character set, language, and database collation that matches your data and avoids character set translation.

For more information, see “Avoiding character-set translation” on page 338.

4Set locales on each of the machines in the environment to these values. For more information, see “Setting locales” on page 346.

5Create your database using the default collation. If the default collation does not match your needs, create a database using a named collation.

344