Print Thread
Chr(10) become Chr(13) and Chr(10)
#51322 04/22/15 08:25 PM
Joined: Apr 2015
Posts: 4
S
Member
OP Offline
Member
S
Joined: Apr 2015
Posts: 4
We have an issue with DOA on Delphi XE5, there is varchar2 string in database which contains line feed (chr(10)), but when use TOracleQuery, FieldAsString, the chr(10) became chr(13) and chr(10). We tested with ADO connection and it works fine. Is there any settings configuration to disable this?

Re: Chr(10) become Chr(13) and Chr(10)
Steven Wu #51325 04/23/15 09:21 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You can set TOracleSession.Preferences.ConvertCRLF to False:
[quote]property ConvertCRLF: Boolean;
Convert between CRLF pairs (Client) and LF (Server). In an Oracle Database, multiple lines of text are separated by just a linefeed (#10) character. On the Windows Operating System, the carriage return / linefeed (#13 / #10) combination is used. Direct Oracle Access will automatically convert between these two conventions. Setting this preference to False will disable this conversion.
[/quote]


Marco Kalter
Allround Automations

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.221s Queries: 13 (0.121s) Memory: 2.5001 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-16 17:15:00 UTC
Valid HTML 5 and Valid CSS