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

UltraLite checksum_level property Next Page

UltraLite collation property

Sets the collation used by the 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 collation=name

From Sybase Central    Use any wizard that creates a database.

On the New Database Collation and Character Set page, choose either the default collation (that is 1252Latin1) or choose an alternate one from the list provided.

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

Any collation name supported by UltraLite. To see a list of collations supported by UltraLite, use the -l option with your database creation utility. Using a database creation wizard, supported collations are listed in the New Database Collation and Character Set page.

See also