| Re: DB upgrade from 8.0.6 to 9.2.0.10 under MVS os/390 [message #63645] |
Sat, 23 October 2004 07:35 |
Raymond
Messages: 30
Registered: September 2000
|
Member |
|
|
Previously our system is running in Oracle 8.0.6 under MVS system.
after our migration on our test machine to 9.2.0.10 and Oracle report6i with patch 13.
OUr report which mainly printing the address is running out of order
What we do at our address columns is we concat
add1 ||chr(13)|| add2 ||chr(13)||add3
Previously on report 4.5 and Oracle 8.0.6 the address is printout correctly.
No 13,Penang Street
Roberson Garden
50190 SG.
Now is
NO 13, Penang Street
ROberson Garden
50190 SG.
I try to test select chr(13) from dual and it give me '|' but when i insert this chr(13) into a varchar2 columns it store as '||' ??
Any comment?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
