The CREATE DATABASE statement allows you to specify whether passwords are to be case sensitive or case insensitive. The case sensitivity setting for passwords is independent of the database case sensitivity setting used for string comparisons. The new CaseSensitivePasswords database property allows you to check the password case sensitivity setting for a database.
For more information, see CREATE DATABASE statement in Sybase IQ Reference Manual.
