bad result for select '1'||chr(10)||chr(10) || '1234' a from dual

[Andrey Maximenko. Ukraine]

select '1'||chr(13)||chr(10) || '1234' a from dual union all
select '1'||chr(10)||chr(10) || '1234' a from dual union all
select '1'||chr(13)||chr(13) || '1234' a from dual

Delphi 7+ DOA 4.1.7

 

[Marco Kalter]

Direct Oracle Access will convert between LF characters on the server and CR/LF pairs on the client. Set TOracleSession.Preferences.ConvertCRLF to False to prevent this.