Print Thread
Oracle support for varchar2(4000+)
#60435 08/15/19 02:58 PM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
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

Re: Oracle support for varchar2(4000+)
Ruudbern #60437 08/16/19 07:05 AM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
Could Session.Preferences.MaxStringFieldSize help me here?

Ruud

Re: Oracle support for varchar2(4000+)
Ruudbern #60438 08/16/19 09:20 AM
Joined: Aug 1999
Posts: 22,198
Member
Offline
Member
Joined: Aug 1999
Posts: 22,198
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.


Marco Kalter
Allround Automations
Re: Oracle support for varchar2(4000+)
Marco Kalter #60439 08/19/19 01:53 PM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
Thanks for your quick response


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.060s Queries: 15 (0.013s) Memory: 2.5029 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-18 16:55:12 UTC
Valid HTML 5 and Valid CSS