Switch to: V11V10V9V8V7V6V5

Valentina Database Properties

On this page you can see list of system Valentina Database properties. You can get the list of properties using SHOW PROPERTIES command.

Localizable properties

AlternateHandling

Read-write system property. Operate with UCOL_ALTERNATE_HANDLING object value.

GET PROPERTY AlternateHandling of database;
SET PROPERTY AlternateHandling of database to 'kDefault';

CaseFirst

Read-write system property. Operate with UCOL_CASE_FIRST object value.

GET PROPERTY CaseFirst of database;
SET PROPERTY CaseFirst of database to 'kDefault';

CaseLevel

Read-write system property. Operate with UCOL_CASE_LEVEL object value.

GET PROPERTY CaseLevel of database;
SET PROPERTY CaseLevel of database to 'kDefault';

FrenchCollation

Read-write system property. Operate with UCOL_FRENCH_COLLATION object value.

GET PROPERTY FrenchCollation of database;
SET PROPERTY FrenchCollation of database to 'kDefault';

HiraganaQuaternaryMode

Read-write system property. Operate with UCOL_HIRAGANA_QUATERNARY_MODE object value.

GET PROPERTY HiraganaQuaternaryMode of database;
SET PROPERTY HiraganaQuaternaryMode of database to 'kDefault';

IOEncoding

Read-write system property. Operate with IO_Encoding object value. It is temporary property (not stored to the schema).

GET PROPERTY IOEncoding of database;
SET PROPERTY IOEncoding of database to 'UTF-16';

LocaleName

Read-write system property. Operate with LocaleName object value.

GET PROPERTY LocaleName of database;
SET PROPERTY LocaleName of database to 'en_US';

NormalizationMode

Read-write system property. Operate with UCOL_NORMALIZATION_MODE object value.

GET PROPERTY NormalizationMode of database;
SET PROPERTY NormalizationMode of database to 'kDefault';

NumericCollation

Read-write system property. Operate with UCOL_NUMERIC_COLLATION object value.

GET PROPERTY NumericCollation of database;
SET PROPERTY NumericCollation of database to 'kDefault';

Strength

Read-write system property. Operate with UCOL_STRENGTH object value.

GET PROPERTY Strength of database;
SET PROPERTY Strength of database to 'kDefault';

Encryptable properties

Encrypted

Read-only system property. Return 1 if object is encrypted and 0 otherwise.

GET PROPERTY Encrypted of database;

RequiresEncryptionKey

Read-only system property. Return 1 if object is a root of encrypted objects tree and 0 otherwise.

GET PROPERTY RequiresEncryptionKey of database;

StructureEncrypted

Read-only system property. Return 1 if object is a structure-encrypted and 0 otherwise.

GET PROPERTY StructureEncrypted of database;

Database properties

CenturyBound

Read-write system property. Operates with CenturyBound database setting. Default value is 20.

GET PROPERTY CenturyBound of database;
SET PROPERTY CenturyBound of database TO 20;

Century1

Read-write system property. Operates with Century1 database setting. Default value is 1900.

GET PROPERTY Century1 of database;
SET PROPERTY Century1 of database TO 1900;

Century2

Read-write system property. Operates with Century2 database setting. Default value is 2000.

GET PROPERTY Century2 of database;
SET PROPERTY Century2 of database TO 2000;

DateTimeFormat

Read-write system property. Operates with DateTimeFormat database setting.

GET PROPERTY DateTimeFormat of database;
SET PROPERTY DateTimeFormat of database TO 'kDMY';

DateSeparator

Read-write system property. Operates with DateSeparator database setting.

GET PROPERTY DateSeparator of database;
SET PROPERTY DateSeparator of database TO '.';

IndexCount

Read-only system property. Operates with IndexCount database value.

GET PROPERTY IndexCount of database;

Journaled

[NEW in v5.0]

Read-write system property. Operates with database journal mode setting. Returns TRUE if this database is Journaled. On default, starting from v5.0, journaling is ON.

You can assign this property to FALSE at runtime for an opened database. You may set it to FALSE (to get better speed (+20%)), but it is not recommended.

GET PROPERTY Journaled of database;
SET PROPERTY Journaled of database TO False;

LinkCount

Read-only system property. Operates with LinkCount database value.

GET PROPERTY LinkCount of database;

Mode

Read-write system property. Operates with database mode setting. Can not be changed if database already exists. Modification is allowed in CREATE DATABASE statement only.

GET PROPERTY Mode of database;
SET PROPERTY Mode of database TO 'kDscDatBlbInd';

ProcedureCount

Read-only system property. Operates with ProcedureCount database value.

GET PROPERTY ProcedureCount of database;

PropertyCount

Read-only system property. Operates with PropertyCount database value.

GET PROPERTY PropertyCount of database;

Path

Read-only system property. Return the path to database.

GET PROPERTY Path of database;

SegmentSize

Read-write system property. Operates with segment size of database volume setting. Can not be changed if database already exists. Modification is allowed in CREATE DATABASE statement only.

GET PROPERTY SegmentSize of database;
SET PROPERTY SegmentSize of database TO 32768;

SchemaVersion

Read-write system property. Operates with database SchemaVersion value. Initial value is 1.

GET PROPERTY SchemaVersion of database;
SET PROPERTY SchemaVersion of database TO 2;

Size

Read-only system property. Return the size of database in bytes.

GET PROPERTY Size of database;

StorageType

Read-only system property. Return the StorageType of database.

GET PROPERTY StorageType of database;

TimeSeparator

Read-write system property. Operates with TimeSeparator database setting.

GET PROPERTY TimeSeparator of database;
SET PROPERTY TimeSeparator of database TO ':';

TriggerCount

Read-only system property. Return the count of triggers value.

GET PROPERTY TriggerCount of database;

ViewCount

Read-only system property. Return the count of views value.

GET PROPERTY ViewCount of database;