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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite creation parameters

 

UltraLite case creation parameter

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

Syntax
{ ulcreate | ulinit | ulload } -o case=value;...
Allowed values

Ignore, Respect

Default

Ignore

Remarks

The case sensitivity of 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. Identifiers (such as table and column names) and user IDs are always case insensitive, regardless of the database case sensitivity. Passwords are always case sensitive, regardless of the case sensitivity of the database. See Strings in UltraLite.

The results of comparisons on strings, and the sort order of strings, depend in part on the case sensitivity of the database.

There are some collations where particular care is required when assuming case insensitivity of identifiers. In particular, Turkish collations have a case-conversion behavior that can cause unexpected and subtle errors. The most common error is that a system object containing a letter I or i is not found.

You cannot change the case of an existing database. Instead, you must create a new database.

From Sybase Central, you can set the case sensitivity in 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, set this parameter as one of the creation parameters for the create database method on the database manager class.

See also