If you use the default actions when creating a Sybase IQ database, your database has the collation ISO_BINENG. This collation provides optimal performance for IQ databases, but not necessarily the most natural sort order. See “Performance issues”.
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.
