Creating a Database with the Default Collation

If you use the default actions when creating an SAP Sybase IQ database, your database has the collation ISO_BINENG.

ISO_BINENG collation provides optimal performance for IQ databases, but not necessarily the most natural sort order.

This differs from SQL Anywhere, which infers the default collation for new databases from the character set in use by the operating system on which the database is created.

If you cannot set up your system in this default manner, decide which collation to use in your database, and whether to use character set translation to ensure that data is exchanged consistently between the pieces of your database system.