Missing Character when selecting over DB Link w/ different character sets
Hi Y'all,
I have an interesting issue here that came up on a test system. Herer's the scenario:
- DB orc1 has a link to DB orc2.
- Column "name" in orc2 contains a row with a "´" (acute accent)
- We "select name from emp@orc2".
- The accent does not show up in the result on orc1.
- orc1 is on WE8ISO8859P15, orc2 on WE8ISO8859P1.
- orc1 is 10.2.0.3, orc2 9.2.0.6.
The accent is there in both character sets, only with different entry points. So, why does it disappear?
Thanks for your input,
Uwe
0