Sybase 12.4.2 manual Character set translation for Sybase Central and Dbisql, 349

CHAPTER 9 International Languages and Character Sets

❖To use the ODBC translation driver:

1In the ODBC Administrator, choose Add to create a new Adaptive Server IQ data source or Configure to edit an existing Adaptive Server IQ data source.

2On the ODBC tab of the ODBC Configuration for Adaptive Server IQ window, click Select and choose Adaptive Server Anywhere 6.0 Translator from the list of translation drivers.

Character set translation for Sybase Central and DBISQL

DBISQL and Sybase Central both employ internal OEM to ANSI code page translation if the database uses an OEM character set. As with the ODBC translation driver, there is an assumption that the OEM code page on the local machine matches the data in the database.

❖To turn off character set translation in DBISQL:

• Set the DBISQL option CHAR_OEM_Translation to a value of OFF.

SET OPTION CHAR_OEM_TRANSLATION = ’OFF’

For more information on OEM to ANSI character set translation in Interactive

SQL, see CHAR_OEM_TRANSLATION option in the Adaptive Server IQ

Reference Manual.

Creating a custom collation

If none of the supplied collations meet your needs, you can modify a supplied collation to create a custom collation. You can then use this custom collation when creating a database.

For a list of supplied collations, see “Supplied collations” on page 329.

❖To create a custom collation:

1Decide on a starting collation.

You should choose a collation as close as possible to the one you want to create as a starting point for your custom collation.

For a listing of supplied collations, see “Understanding collations” on page 328.

2Create a custom collation file.

349