Oracle support for varchar2(4000+)

[Ruudbern]

Hi,

do the direct oracle access components support the oracle 12c extended strings? Varchar2 longer than 4000;
One of our customers changed max_string_size to EXTENDED and almost immediately runs into access violations.

thanks in advance

Ruud

 

[Ruudbern]

Could Session.Preferences.MaxStringFieldSize help me here?

Ruud

 

[Marco Kalter]

When extended strings are enabled you can run into problems with query fields that are based on character operations or character function results, even if all table character columns are smaller than 4000 bytes.

 

[Ruudbern]

Thanks for your quick response