Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

Configurable properties in UltraLite Next Page

UltraLite case property

Sets the case sensitivity of string comparisons in the UltraLite database.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented 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.

Allowed values

Ignore, Respect




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.

See also