Devart Forums

we have an Oracle DB with NLS_CHARACTERSET = AL32UTF8
and set in SpecificOptions: UseUnicode = true

the problem is: when a field is declared as VARCHAR2(1 CHAR), the value of TWideStringField.Size is 4.

Is it possible to get the declared size in characters?
Better: set the 'correct' value to TWideStringField.Size

This would also fit the definition of TStringField in Delphi Help (ftString | Size is the maximum number of characters in the string).

Hello,

If field is defined as VARCHAR2(X CHAR) in a database with the AL32UTF8 encoding, the maximum length of one symbol is 4, and that's why we set the maximum field size by default. If you want to change this value, you should change the CharLength parameter:

UniConnection1.SpecificOptions.Values['CharLength'] := 2;