Performance for character data is better with a binary character set and collation sequence than with a non-binary character set and collation sequence.
To maximize performance, create a database with these default option settings:
CREATE DATABASE dbname COLLATION 'ISO_BINENG' CASE RESPECT
These options result in a binary character set and collation sequence. All other settings for these two options form a non-binary character set and collation sequence.
The disadvantage of these settings is that uppercase characters are always sorted before lowercase ones. For example, BANANA sorts before apple. If you prefer a more natural sort order, but still need a case sensitive database, and you are willing to sacrifice some degree of performance, use the collation ISO_1 instead of the default, ISO_BINENG.
For
details about password case-sensitivity, see “User
IDs and passwords” in Appendix
A, “Compatibility with Other Sybase Databases,”in Reference: Building Blocks, Tables, and Procedures.
