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

SQL Anywhere 12.0.1 » UltraLite - Database Management and Reference » UltraLite database creation


Specify UltraLite creation parameters

Creation parameters are used to configure the UltraLite database when you first create it. You can only change these settings by recreating the database.

There are several options you can control when creating your UltraLite database. These are designed to help with the wide variety of UltraLite uses. Note that most parameters specified at creation time cannot be changed later.

You can specify creation parameters when creating a database using the ulinit or ulload utility, and from the supported client interfaces.

Boolean creation parameters are turned on with YES, Y, ON, TRUE, T, or 1, and are turned off with any of NO, N, OFF, FALSE, F, and 0. The parameters are case insensitive.

UltraLite creation parameters are specified in a semicolon separated string when creating a database from a programming interfaces and as a separate command line parameters when using a command line utility. For example:

ulinit --case --utf8_encoding=1 test.udb

Alternatively, you can specify multiple -c options.

You can further configure other aspects of your database with database options and connection parameters.

 Accessing creation parameter values
 See also