If you use the default actions when creating an 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. For more information, see “Performance issues”.
Note that this differs from Adaptive Server 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 it is not possible to set up your system in this default manner, you need to 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. This chapter provides the information you need to make and implement these decisions.
