Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration

International languages and character sets

Internationalization refers to the ability of software to handle a variety of languages and their appropriate characters sets, independently of the language in which the software is running, or the operating system on which the software is running.

The following features discuss the most commonly requested and used capabilities.

  • Unicode support

    Unicode is supported as follows:

    • Client support for UTF-16 in SQL Anywhere client libraries for ODBC, OLE DB, ADO.NET, and JDBC

    • NCHAR data types for storing Unicode character data in UTF-8

    • CHAR data types can use UTF-8 encoding

  • Code pages and character sets

    The database server and related tools support Windows (ANSI/ISO), UTF-8, and Unix code pages and character sets.

  • Collations

    Two collation algorithms are supported: the SQL Anywhere Collation Algorithm (SACA), and the Unicode Collation Algorithm (UCA) using International Components for Unicode (ICU).

    SACA provides fast, compact, and reasonable sorting at the expense of linguistic correctness. UCA provides linguistic correctness, but with a small expense in storage requirements and execution time.

    For advanced ordering and comparison capabilities, the SORTKEY and COMPARE functions are also provided. These functions provide advanced linguistic sorting capabilities, like the ordering found in a dictionary or telephone book. Where appropriate, case-insensitive and accent-insensitive ordering and comparisons are provided.

    Design features allowing for automatic use of SORTKEY-based ordering on character columns are also included. The sort_collation database option specifies the sort ordering to be used when an ORDER BY is specified for a character column. Computed columns may also be used to store sort keys for character columns so that they do not need to be computed each time that an ORDER BY is specified.

  • Character set conversion

    Data is converted between the character set encoding on your server and client systems. The integrity of your data is maintained even in mixed character set environments.

  • Identifiers

    The use of identifiers containing most single-byte and multibyte characters are supported without requiring quotes. Exceptions are generally limited to spaces and punctuation symbols.

  • Currency

    Currency symbols, including the euro symbol, are supported for ordering. No currency formatting support is provided.

  • Date and time formats

    The Gregorian calendar is supported, and a variety of formats for date and time strings are provided. Custom formatting can be done using the date_format, time_format, and timestamp_format database options. The date_format and timestamp_format options default to an ISO-compatible format for the date, YYYY-MM-DD. The CONVERT function, which provides output formatting of dates and times into a variety of popular formats, is provided.