UltraLite database properties

Property

Description

case

Returns the status of the case sensitivity feature. Returns On if the database is case sensitive. Otherwise, it returns Off.
The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite case creation parameter.

char_set

Returns the CHAR character set of the database. The character set used by the database is determined by the database's collation
sequence and whether the data is UTF-8 encoded.

The value of this property is set when the database is created, and can only be changed by creating a new database.

checksum_level

Returns the level of checksum validation in the database, one of 0 (do not add checksums), 1 (add checksums only to important
pages), or 2 (add checksums to all pages). The value of this property is set when the database is created, and can only be
changed by creating a new database. See UltraLite checksum_level creation parameter.

collation

Returns the name of the database's collation sequence. The value of this property is set when the database is created, and
can only be changed by creating a new database. See UltraLite collation creation parameter.

Returns the number of connections to the database. The value is dynamic: it can vary depending on how many connections currently
exist. UltraLite supports up to fourteen concurrent database connections.

date_format

Returns the date format the database uses for string conversions. The value of this property is set when the database is created,
and can only be changed by creating a new database. See UltraLite date_format creation parameter.

date_order

Returns the date order the database uses for string conversions. The value of this property is set when the database is created,
and can only be changed by creating a new database. See UltraLite date_order creation parameter.

encryption

Returns the type of database encryption, one of None, Simple, AES, or AES_FIPS.

The encryption used by the database is determined by whether or not you have configured strong encryption (AES or AES_FIPS)
and the DBKEY creation parameter, or obfuscation (simple encryption).

The only time this property can change is when the value is originally None (that is, neither fips nor obfuscation is used)
and you then change the encryption key by specifying a new encryption key on the Connection object by calling the correct
function or method for your API. In this case, the value would change to AES because the fips creation parameter cannot be
set after the database has been created. See:

Returns the value of the ml_remote_id option that uniquely identifies the database for MobiLink synchronization. See UltraLite ml_remote_id option.

name

Returns the name (or alias) of the database for the current connection. The name returned matches the DBN connection parameter
value. If you did not use the DBN connection parameter, the name returned is the database file without the path and extension.

Returns the nearest century the database uses for string conversions. The value of this property is set when the database
is created, and can only be changed by creating a new database. See UltraLite nearest_century creation parameter.

page_size

Returns the page size of the database, in bytes. The value of this property is set when the database is created, and can only
be changed by creating a new database. See UltraLite page_size creation parameter.

precision

Returns the floating-point precision the database uses for string conversions. The value of this property is set when the
database is created, and can only be changed by creating a new database. See UltraLite precision creation parameter.

scale

Returns the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION
during string conversions by the database. The value of this property is set when the database is created, and can only be
changed by creating a new database. See UltraLite scale creation parameter.

time_format

Returns the time format the database uses for string conversions. The value of this property is set when the database is created,
and can only be changed by creating a new database. See UltraLite time_format creation parameter.

timestamp_format

Returns the timestamp format the database uses for string conversions. The value of this property is set when the database
is created, and can only be changed by creating a new database. See UltraLite timestamp_format creation parameter.

timestamp_increment

Returns the minimum difference between two unique timestamps, in microseconds. The value of this property is set when the
database is created, and can only be changed by creating a new database. See UltraLite timestamp_increment creation parameter.