Chr(10) become Chr(13) and Chr(10)

[Steven Wu]

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?

 

[Marco Kalter]

You can set TOracleSession.Preferences.ConvertCRLF to False:

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.