Sybase IQ 12.6 includes several changes to international languages, listed below. For details of these features, see Chapter 11, “International Languages and Character Sets” in Sybase IQ System Administration Guide.
New Lithuanian and Turkish collations There are two new collations available: one to support Lithuanian (1257LIT, ANSI Code Page 1257) and one to support Turkish (1254TRKALT). This Turkish collation considers I-dot and I-no-dot equal.
New Greek collation for Windows environment (behavior change) Greek collations for OEM/DOS character sets existed in previous versions, however, a new Greek collation, 1253ELL, has been added for Windows. When creating a new database in a Greek Windows environment, 1253ELL will be selected automatically if a collation is not specified.
Deprecated collations (behavior change) The following collations are no longer supported. Where indicated, they have been superseded by different collations:
Deprecated |
Superseded by |
|---|---|
437 |
437LATIN1 |
850 |
850LATIN1 |
852 |
852LATIN2 |
860 |
860LATIN1 |
863 |
863LATIN1 |
865 |
865NOR |
SJIS |
932JPN |
SJIS2 |
932JPN |
WIN_LATIN1 |
1252LATIN1 |
WIN_LATIN5 |
1254TRK |
Internal |
850LATIN1 |
437EBCDIC |
Custom collation changes (behavior change) Previously, the -d option
in the Collation utility accepted three parameters; now it accepts
only two parameters. The cust-map-file parameter
is no longer accepted. The syntax for the Collation utility is
dbcollat -d coll-defn-file custom-file
As well, the script files collsqmp.sql and custmap.sql are no longer present and cannot be used for built-in or custom collations, respectively.
For newly-created databases, the SYSCOLLATIONMAPPINGS table contains only one row with the collation mapping. For databases created with previous versions of Adaptive Server Anywhere, this table contains a row for each built-in collation.
Character set conversion function A new function CSCONVERT is available to convert strings between character sets. For best performance, avoid using the CSCONVERT keyword in predicates, as CIS functional compensation performance considerations apply. For more information, see Adaptive Server Anywhere SQL Reference.
ON_CHARSET_CONVERSION_FAILURE option A new option controls what happens if an error is encountered during character conversion. For more information, see “ON_CHARSET_CONVERSION_FAILURE option” in Sybase IQ Reference Manual.
Determining the language for interfaces and messages (behavior change) Two new environment variables, ASLANG and ASCHARSET, control languages used in interfaces (such as Sybase Central or Interactive SQL) and messages. ASLANG specifies the language, and ASCHARSET specifies the character set.
For more information, see “ASCHARSET environment variable” and “ASLANG environment variable” in Sybase IQ Reference Manual.
SQLLOCALE environment variable no longer supported (behavior change) SQLLOCALE environment variable has been replaced by two new environment variables, ASLANG and ASCHARSET.
Clients ignore SQLLOCALE environment variable (behavior change) Clients can use the CharSet connection parameter to specify the character set to be used on a connection. In previous versions of Adaptive Server Anywhere, the CHARSET parameter of the SQLLOCALE environment variable was used to change the client's default character set if the CharSet connection parameter was not supplied. Clients now ignore the SQLLOCALE environment variable.
For more information, see “CharSet connection parameter [CS]” in Sybase IQ System Administration Guide.
Unsupported character sets cause connection failure (behavior change) Clients can use the CharSet connection parameter to specify the character set to be used on a connection. However, if the server does not support the requested character set, the connection fails. When a client requested an unsupported character set in previous versions, the connection succeeded with a warning. If the client does not specify a character set, but the client's local character set is unsupported by the server, the connection succeeds, but with a warning that the character set is not supported.
See also “Changes to server command line options” for a related behavior change.
Viewing collation label and name for custom collations The dbinfo command line utility now returns the collation label and name for custom collations. As well, two new fields, collationnamebuffer and collationnamebufsize, have been added to the a_db_info structure in dbtools.h.
For more information, see “The Information utility (dbinfo)” in Sybase IQ Utility Guide and “a_db_info structure” in Adaptive Server Anywhere Programming Guide.
Full-length and abbreviated day names are recognized in all supported languages for event schedules (behavior change) When creating events, the database server recognizes both full-length and abbreviated English day names, in any of the languages supported by Sybase IQ. Previously, schedules in non-English languages required full day names.
For more information, see “CREATE EVENT statement” of Sybase IQ Reference Manual.
Adaptive Server Anywhere Translation Driver removed (behavior change) Use of translation drivers is no longer recommended. The server automatically handles character set translation.
