Sybase 12.4.2 manual Understanding the locale character set, 325

CHAPTER 9 International Languages and Character Sets

Language label values The following table shows the valid language label values, together with the equivalent ISO 639 labels:

	Alternative
Language label	label	ISO_639 language code
us_english	english	EN
french	N/A	FR
german	N/A	DE
spanish	N/A	ES
japanese	N/A	JA
korean	N/A	KO
portuguese	portugue	PT
chinese	simpchin	ZH
italian	N/A	IT
tchinese	tradchin	TW
polish	N/A	PL
norwegian	norweg	NO
swedish	N/A	SV
danish	N/A	DA

Understanding the locale character set

Both application and server locale definitions have a character set. The application uses its character set when requesting character strings from the server. If character set translation is enabled, the database server compares its character set with that of the application to determine whether character set translation is needed.

For a list of available character set labels, see “Character set labels” on page 326.

For how to find locale settings, see “Determining locale information” on page 345.

The client library or database server determines the character set as follows:

1If the connection string specifies a character set, it is used.

For more information, see the CharSet connection parameter in the Adaptive Server IQ Reference Manual.

2ODBC and Embedded SQL applications check the SQLLOCALE environment variable, if it exists.

325