Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 369 / 536

CHAPTER 9 International Languages and Character Sets
349
❖
To use the ODBC translation driver:
1 In 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.
2 On 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:
1 Decide 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.
2 Create a custom collation file.