The following collations that were available in 12.6 and 12.7 are deprecated in Sybase IQ 15.0:
437EBCDIC – Code Page 437, EBCDIC ordering
437ESP – Code Page 437, Spanish
437LATIN1 – Code Page 437, Latin 1, Western
819DAN – Code Page 819, Danish
819ESP – Code Page 819, Spanish
819ISL – Code Page 819, Icelandic
819LATIN1 – Code Page 819, Latin 1, Western
819NOR – Code Page 819, Norwegian
819SVE – Code Page 819, Swedish/Finnish
850DAN – Code Page 850, Danish
850ESP – Code Page 850, Spanish
850ISL – Code Page 850, Icelandic
850LATIN1 – Code Page 850, Latin 1, Western
850NOR – Code Page 850, Norwegian
850SVE – Code Page 850, Swedish/Finnish
852CYR – Code Page 852, Cyrillic
852LATIN2 – Code Page 852, Latin 2, Central/Eastern European
852POL – Code Page 852, Polish
855CYR – Code Page 855, Cyrillic
856HEB – Code Page 856, Hebrew
857TRK – Code Page 857, Turkish
860LATIN1 – Code Page 860, Latin 1, Western
861ISL – Code Page 861, Icelandic
862HEB – Code Page 862, Hebrew
863LATIN1 – Code Page 863, Latin 1, Western
865NOR – Code Page 865, Norwegian
866RUS – Code Page 866, Russian
869ELL – Code Page 869, Greek
920TRK – Code Page 920, Turkish, ISO 8859-9
950TWN – Code Page 950, Traditional Chinese, Big 5 Encoding
1252DEU – Code Page 1252, Windows Specialty German, Umlaut chars not equal
C – Standard C collation
internal – Code Page 850, Multilingual
SJIS – Japanese Shift-JIS Encoding
SJIS2 – Japanese Shift-JIS Encoding, ASE-compatible
UTF8 – UTF-8, 8-bit multibyte encoding for Unicode, legacy ordering
WIN_LATIN1 – Code Page 1252, Windows Latin 1, Western, ISO8859-1 with extensions
WIN_LATIN5 – Code Page 1254, Windows Latin 5, Turkish, ISO8859-9 with extensions
You can use the iqunload utility to migrate to Sybase IQ 15.0 an existing 12.6 or 12.7 database that was created with a deprecated collation. For details about iqunload, see the Installation and Configuration Guide.
The deprecated collations are no longer visible in the Sybase Central list of supported collations. Although the SQL syntax still allows you to create new databases with the deprecated collations, creating new databases using these deprecated collations is not recommended.
