I Have an DB with AL32UTF8 Charset.
All Tables with varchar2, length set with char.
Delphi XE3 with DOA 4.1.3.5

TOracleSession set
BytesPerCharacter to bcAutoDetect
Preferences.ConvertUTF to cuUTF8TOUTF16
Preferences.ForceWideStringField to true

If I set Fields to Dataset the tfield.size are 4*charsize,
but it is wrong, Field.Size are Chars not Byte.

Then I get the hole Data from the field, but the tbdedit length too large, i can insert more chars than the db can insert.

If I set OracleDictionary.CharterSize=true, then the Tfield.Size right.
Then I get too small data from the db if data has 2Byte Chars like
Hello,

can nobody explain how unicode works with doa?
Which property must i set in doa and which parameter must i set in
the database, that it all works fine?
Dear Marco,

We have the same problem. Do You have any solution?

regards
Sandor
© Allround Automations forums