Funky query (cuts off results)

[Peter Zolja]

I ran across a funky query:

select 'line1'||chr(10)||chr(13)||'line2' from dual;

it seems to be cutting off the last two characters ("e2"). Any ideas? (the same query used with the ADO components - D7 - works fine).

Thanks. (I think my version is 4.0.5.0, has this been fixed since?)

 

[Michael Ellermann]

Hi,

I have the same Problem !

It works fine with HORA (Keeptool SQl Tool), SQL Plus, but cuts off last two characters with DOA 4.0.6.2 and Delphi 5 Enterprise on a Oracle 10g R2
Very strange !! makes me a bit nervous as we supply about 100 customers with our software, using DOA...

best regards michael

 

[Michael Ellermann]

Good morning,

this statement delivers a ! correct ! answer:

select 'line1'||chr(10)||chr(13)||'line2__' from dual;

DOA definitly cuts off last two characters....

Any Idea about workaround ??

Michael

 

[Michael Ellermann]

Okay,

now I am nervous, try this:

with this statement it cuts of the last four characters:

select 'line1'||chr(10)||chr(13)||'line2'||chr(10)||chr(13)||'line3' from dual

Michael
PS: I know, I know, last post until i get an answer, promise...

works fine this way:
select 'line1'||chr(13)||chr(10)||'line2'||chr(13)||chr(10)||'line3' from dual

 

[Peter Zolja]

I believe it has to do with the chr(10)||chr(13); if you put the correct CRLF, which is chr(13}||chr(10), it works just fine...

 

[Peter Zolja]

"works fine this way:
select 'line1'||chr(13)||chr(10)||'line2'||chr(13)||chr(10)||'line3' from dual"

sorry, I should've read the whole post before replying