Switch to: V12V11V10V9V8V7V6V5

Property Inspector: Database

This page describes properties listed for a Database object.

Category "Object"

  • Class - Specifies the class of the selected object.
  • Name - The name of the selected database.
  • Path - Displays the address of the database. This can be an address on a network or, like in the example, locally on your PC. Right you the path you can icon to show this database on disk.
  • Comment - Comment to this database.

Category "Settings"

  • Mode - Specifies the storage mode of the database.
  • Segment Size -
  • Storage Type - Indicates wether the database is stored on disk or in RAM.
  • Byte Order - Indicates the Byte Order - Big Endian or Little Endian.
  • Schema Version - Version of database schema. Developer can change it when needed.
  • Date Format - The alignment of days, months and years in a date specification. D stands for day, M for month, y for year. Every letter stands for one digit.
  • Date Separator - The separating symbol between days, months and years.
  • Time Separator - The separating symbol between hours, minutes and seconds.

Category "Century Correction"

Defines with which century a date specification with only 2 year digits is completed.

  • Century 1 - The century inserted for a date below the bound.
  • Century 2 - The century inserted for a date above the bound.
  • Bound - The bound up to which “Century 1” applies.

In the example, the date specification “3.10.50” automatically is completed to “03.10.1950”, while “17.4.18” is completed to “17.04.2018”. The boundary is the 01.01.1921 resp. 31.12.2020. To define a date beyond that time span of 100 years, simply define the year with 4 digits.

Category "Collation Settings"

Valentina database engine uses IBM ICU - the most powerful unicode library. This library provides very reach set of collator parameters that are listed in this category. You can read more details in Valentina engine docs here and IBM ICU docs here.

  • Locale Name - Displays the name of the used locale (language and country specifications).
  • Storage Encoding - Encoding used to store strings on the disk.
  • Alternate Handling - The Alternate attribute is used to control the handling of the so-called variable characters in the UCA: whitespace, punctuation and symbols. The default for most locales is Non-Ignorable.
  • Case First - is used to control whether uppercase letters come before lowercase letters or vice versa, in the absence of other differences in the strings.
  • Case Level - is used when ignoring accents but not case. In such a situation, set Strength to be Primary, and Case_Level to be On. In most locales, this setting is Off by default.
  • French Collation - The French sort strings with different accents from the back of the string. This attribute is automatically set to On for the French locales and a few others. Users normally would not need to explicitly set this attribute.
  • Quaternary Mode -
  • Normalization Mode -
  • Strength - Specifies the level of string comparison:
    • Primary Level: Typically, this is used to denote differences between base characters (for example, “a” < “b”).
    • Secondary Level: Accents in the characters are considered secondary differences (for example, “as” < “às” < “at”).
    • Tertiary Level: Upper and lower case differences in characters are distinguished at the tertiary level (for example, “ao” < “Ao” < “aò”).
    • Quaternary Level: When punctuation is ignored (for example, “ab” < “a-b” < “aB”).
    • Identical Level: When all other levels are equal, the identical level is used as a tiebreaker. The Unicode code point values of the NFD form of each string are compared at this level, just in case there is no difference at levels 1-4 .

See also: Collation Settings page.

Category "Information"

  • Table Count - The number of tables in the database.
  • Index Count - The number of indexes in the database.
  • Link Count - The number of links in the database.
  • Size - The size of the database on disk/RAM.