The "typical" SQL DBMS supports most of the standard character data types, but often uses preferred local names. For example, Oracle has a 2000-byte maximum (2048 for Oracle Lite) for the CHAR <data type> and offers a (non-standard) LONG VARCHAR type to define larger character string fields.

Sybase allows for a large variety of Character sets, with only one "group" (Character set) allowed at a time. Baltic languages are in the East European group (8859-2), though it doesn't seem possible to get a correct result in this case. Collations supported are: English+French+German (all together!), Spanish, Hungarian, Russian; then everything else is binary. Sybase does not support SQL CHARACTER SETs, COLLATIONs or TRANSLATIONs, nor does it support CONVERT -- to convert you need an offline utility. It does provide some Unicode support.

Comments

Comments loading...