Property Inspector: Field / Method

This page describes properties listed for a Field object.

• Class - Specifies the class of the selected object.
• Name - The name of the selected table.
• ID - The internal ID of the object.
• Type - Specifies the field type.

for String, VarChar, Fixedbinary, BarBinary:

• Length - Specifies the length of the field.

for BLOB:

• Segment Size - Specifies the segment size for a BLOB field.

for ObjectPtr:

• Deletion Control - Specifies the action Valentina will take on deletion of the parent table of that link (ObjectPtr fields are a link type).

• Nullable - Indicates wether the field is flagged as nullable.
• Indexed - Indicates wether the field is flagged as indexed.
• Unique - Indicates wether the field is flagged as unique.
• Index By Words - Indicates wether index build algorithm should split strings by words.

• Compressed - Indicates wether the content of a BLOB field is compressed.
• Encrypted - Indicates if the field is encrypted.

For more information on flags, see the VKernel documentation.

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.
• Normalization - If set to on, a quick check and neccessary normalization will be performed.
• Numeric Collation - If set to on, then sequences of decimal digits (gc=Nd) sort by their numeric value (aka natural sort order).
• Quaternary - deprecated.
• 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.

• Property Count - The number of properties defined for this this table.
• Size - The size of this field on disk/in RAM.