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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference

UltraLite options

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

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

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

UltraLite creation options are specified as a semicolon separated list when creating a database from a programming interface.

You can use a prefix with an option to specify that the option applies only when an application is running on a particular type of platform.

Use the prefix desktop: with an option to indicate that the option only applies when the application is running on the desktop.

Use the prefix device: with an option to indicate that the option only applies when the application is running on the mobile device.

Note If the option is appropriate for both desktop and mobile device, then do not use the prefix.
device:DBF=\Documents\sample.udb;desktop:DBF=c:\Databases\sample.udb;UID=DBA;device:DBKEY=secret
Name Description Syntax
case Sets the case-sensitivity of string comparisons in the UltraLite database.
case=value
checksum_level Sets the level of checksum validation in the database.
checksum_level=value
collation Sets the collation sequence used by the UltraLite database. Setting this property with or without the UTF-8 property determines the character set of the database.
collation=value
date_format Sets the default string format in which dates are retrieved from the database.
date_format=value
date_order Controls the interpretation of date ordering of months, days, and years.
date_order=value
dbf

Specifies the path and file name for an UltraLite database.

dbf=database-file
dbkey

Provides an encryption key for the database.

dbkey=string
fips Controls the use of FIPS-certified AES encryption.
fips=value
kdf_iterations Makes it more difficult to access an encrypted database by prolonging each attack attempt.
kdf_iterations=value
max_hash_size Sets the default index hash size in bytes.
max_hash_size=value
mirror_file

Specifies the name of the database mirror file to which all database writes will be issued (at the same time as they are to the main database file).

mirror_file=mirror-file
nearest_century Controls the interpretation of two-digit years in string-to-date conversions.
nearest_century=value
obfuscate Controls whether data in the database is obfuscated. Obfuscation is not secure against skilled and determined attempts to gain access to the data.
obfuscate=value
page_size Defines the database page size.
page_size=sizek 
precision Specifies the maximum number of digits in decimal point arithmetic results.
precision=value
pwd

Sets the password for the user.

pwd=password
reserve_size

Pre-allocates the file system space required for your UltraLite database, without actually inserting any data.

reserve_size=number{ k | m | g }
scale Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision.
scale=value
time_format Sets the format for times retrieved from the database.
time_format=value
timestamp_format Sets the format for timestamps retrieved from the database.
timestamp_format=value
timestamp_increment Determines how the timestamp is truncated in UltraLite.
timestamp_increment=value
timestamp_with_time_zone_format This option sets the format for TIMESTAMP WITH TIME ZONE values retrieved from the database.
timestamp_with_time_zone_format=value
uid

Sets the default user ID for the database.

uid=user
utf8_encoding Encodes data using the UTF-8 format, 8-bit multibyte encoding for Unicode.
utf8_encoding=value