Valentina DB maybe the only database engine which gives you ability to specify collator properties of the Database->Table->Field chain using inheritance.
For example, you can specify Collator.strength = kPrimary for Database object, and all its tables and their fields also will get the same value.
Even better. You can specify another value for some table or field, e.g. tblPersonFrench.Collator.strength = kSecondary, which overrides settings of parent object. If later you decide to change Database.Collator.strength to e.g. kTertiary, then all tables except tblPersonFrench inherit this new value. But tblPersonFrench will preserve its own value kSecondary. And finally, you may want drop this own value of object to force it to use parent’s value.
From now (v5.0) Valentina Studio is able:
- to display the fact that some property of collator of an object (database/table/field) has own value, in BOLD STYLE
- to force an object to use parent settings using a contextual menu command