Database Administration (MOSC)

MOSC Banner

Missing Character when selecting over DB Link w/ different character sets

edited Sep 7, 2009 10:25PM in Database Administration (MOSC) 2 commentsAnswered ✓
 Hi Y'all,

I have an interesting issue here that came up on a test system. Herer's the scenario:

  1. DB orc1 has a link to DB orc2.
  2. Column "name" in orc2 contains a row with a "´" (acute accent)
  3. We "select name from emp@orc2".
  4. The accent does not show up in the result on orc1.
  5. orc1 is on WE8ISO8859P15, orc2 on WE8ISO8859P1.
  6. 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center