|
Sets the case sensitivity of string comparisons in the UltraLite database.
UltraLite employs different methods for setting this property:
| Context | Implemented by |
|---|---|
|
From the command line Use any utility that creates a database. |
Use the following property syntax: - o case=value |
|
From Sybase Central Use any wizard that creates a database. |
On the New Database Collation and Character Set page, select the Use Case-sensitive String Comparisons option. |
|
From a client application Use the create database method. |
Set this property as one of the creation parameters for an API's create database method on the database manager class. |
Ignore, Respect
Ignore
You cannot change the case of an existing database. Instead, you must create a new database.
The case sensitivity of the data is reflected in tables, indexes, and so on. By default, UltraLite databases perform case-insensitive comparisons, although data is always held in the case in which you enter it. Passwords are always case sensitive, regardless of the case sensitivity of the database.