Devart Forums

I have a table people:
lastname varchar2(50),
firstname varchar2(50).

SELECT * from people in a crdbgrid=> Width of columns is fine.
However, alter table people modify (lastname varchar2(50 char), firstname varchar2(50 char));
=> Then run same app. The width of both columns has been multiplied by 4. Is it possible to avoid this? Even if encoding takes 4 bytes, only one char is displayed, so width should not change!

Regards.

hello,

This is the correct behavior when using Varchar2 (char) fields at the Unicode base. To avoid the field size multiplying by 4, you can either forcibly set the OraSession1.Options.CharLength option to 1 (in this case, the string including UniCode symbols, which size is larger than 1 byte, will be cut), or set the OraSession1.Options.UseUnicode property to True (in this case, the size of fields will be calculated in symbols)