Problem with Unicode DB

[FrecciaRossa]

Delphi 2009, DevExpress Version Build 47, DOA 4.1.2.2

Hello,

i am migrating an application from oracle 9i to an unicode DB on Oracle 11g. To get it work i had to change TSringfields to TwideStringfields.

My problem:
i have to use hundreds of DevExpress Components like TcxDBTextEdit and most of them are bound to TWideStringfields.
Until the migration to unicode MaxLength of TcxDBTextField was assigned automatically with the value of size of the TStringField in a correct way (because it reflected the length in characters). But now in TWideStringfield the value of size is 2 times the character length and so MaxLength is assigned in a wrong way. Any way to let size of TWideStringfield expose the length in characters?
Any way to get this work without the need to specify MaxLength (of the user controls) everywhere manually?

many thanks in advance ...

 

[FrecciaRossa]

The size proposed by DOA now (for a varchar2( 10 CHARACTER) field)
with this Option set:
ConvertUTF: cuUTF8ToUTF16
is 40 (which should be correct)

All other properties of Sessionmanager are default;

but with size at 40 at the upper layers i will get a mess;
With size at 10 i have problems with DOA

....

 

[Carlo Sirna]

it is not correct!
TField.Size for ftString fields (TStringField and TWideStringField) is supposed to contain the number of characters, not the size in bytes required to store them

http://docwiki.embarcadero.com/VCL/en/DB.TField.Size

"ftString Size is the maximum number of characters in the string."

Applies also to ftMemo.