TMemoField.Transliterate Property

Determines whether any text in the BLOB field should be converted to and from the character set identified by the dataset.

Pascal

property Transliterate: Boolean;

C++

__property Boolean Transliterate;

Description

Use Transliterate when the physical database table identified by the dataset does not use an ANSI language driver and the data may contain extended ASCII characters uses a different character set than UTF-8 (on Linux) or ANSI (on Windows) and the BLOB field contains text.

When Transliterate is true, BLOB fields call the dataset's Translate method to translate ANSI UTF-8 characters to the character set used by the dataset when the value is changed using the Value property, the AsString property, or the AsVariant property. When these properties are read to obtain the value of the BLOB field, the Translate method translates the characters in the database table to the UTF-8 (Linux) or ANSI (Windows) character set.

Note: BLOB streams (returned by the dataset's CreateBlobStream method) also check the Transliterate property when reading from or writing to a BLOB field.