Filter
Top Products
CHAPTER 9 International Languages and Character Sets
329
• The collation (ASA_Label)
• Case sensitivity (Case)
• Blank padding (Blank Padding) if it was specified when the database was
created.
You can also see the collation of your current database by using the
dbcollat
utility to write the collation into a file:
dbcollat -c "
connection-string
"
filename
For example, you might extract the collation from the asiqdemo database as
follows:
dbcollat -c "uid=DBA;pwd=SQL;eng=myhost_asiqdemo"
demo_col
You can display the contents of filename from the File menu in dbisql.
To see details of any collation that exists on your system, use the
-z option of
dbcollat. For example, to extract collation 850, you could enter:
dbcollat -c "uid=DBA;pwd=SQL;eng=myhost_asiqdemo" -z
850 demo_col
Supplied collations
The following collations are supplied with Adaptive Server IQ.
Collation
label Type Description
437LATIN1 OEM Code Page 437, Latin 1, Western
437ESP OEM Code Page 437, Spanish
437SVE OEM Code Page 437, Swedish/Finnish
819CYR ANSI Code Page 819, Cyrillic
819DAN ANSI Code Page 819, Danish
819ELL ANSI Code Page 819, Greek
819ESP ANSI Code Page 819, Spanish
819ISL ANSI Code Page 819, Icelandic
819LATIN1 ANSI Code Page 819, Latin 1, Western
819LATIN2 ANSI Code Page 819, Latin 2, Central/Eastern
European
819NOR ANSI Code Page 819, Norwegian
819RUS ANSI Code Page 819, Russian