HI
We have an Oracle client on a BS2000 (Siemens mainframe) and the database resides on an AIX.
The server is WE8ISO8859P1 and the client is WE8BS2000.
According to the user on that machine (I'm not able to test myself), some special chars gets replaced by ? indicating that a conversion cannot take place. I have tried to make a:
select adr1, convert(adr1, 'WE8BS2000', 'WE8ISO8859P1'),
convert(convert(adr1, 'WE8BS2000', 'WE8ISO8859P1'),'WE8ISO8859P1','WE8BS2000')
from hans;
from my own client (windows) involving the 2 charsets mentioned.
And the 1 and 3rd column are the same (indication to me that the conversion is correct and lossless from and to).
-----
But is there a way to see how things are converted ? Char to char ?
Can you make a select from dual ... giving a matrix of to & from chars ? (something with connect by 16 times 16). I cant figure the algorithm out)
But the result could be
00 01 02 03 04 05 06 07 08 09 10 1A........ translates to 20 21 22 or whatever they translate into
10 11 12
20 21
I have tried to look into the Globalization Guide ..... but with little success.
Best regards
Mette
PS Is there a possiblity of specifying the replacement character other than ?