Sets the database collation.

Syntax

{ ulcreate | ulinit | ulload } -o collation=value;...

Allowed values

String

Default

1252Latin1

Remarks

For a list of supported collations in UltraLite, see UltraLite supported collations.

You can also view a list of supported collations in UltraLite by executing the following command:

ulcreate -l

From Sybase Central, you can set the collation in any wizard that creates a database. On the New Database Collation And Character Set page, choose either the default collation (1252Latin1), or an alternate one from the list.

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

• UltraLite Create Database utility (ulcreate)
• UltraLite Initialize Database utility (ulinit)
• UltraLite Load XML to Database utility (ulload)
• UltraLite character sets
• UltraLite for embedded SQL: ULCreateDatabase function
• UltraLite for C++: CreateDatabase function
• UltraLite.NET: CreateDatabase method
• UltraLite for M-Business Anywhere: createDatabase method
• Accessing creation parameter values