Sybase 12.4.2 Manuale Utente

International language and character set tasks

 

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

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.

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.

❖

1

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

2

Decide whether the locale settings are appropriate for your environment.

For more information, see “Understanding collations” on page 328.

3

If 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.

4

Set locales on each of the machines in the environment to these values.

For more information, see “Setting locales” on page 346.

5

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