SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with character conversion across database link

398308May 28 2009 — edited May 28 2009

Hello

I'm currently having trouble converting a varchar2 from 'EE8ISO8859P2' to 'AL32UTF8' accross a database link

The remote database which I link to uses NLS_CHARACTERSET='EE8ISO8859P2'

My primary database where my SQL is running uses NLS_CHARACTERSET='AL32UTF8'

In the remotebase I have the name "Jež"

If I just ignore the problem, and use a query like "select name from table@remotedb" i get "Je×" selected into my primary database

If I try using the convert function using "select CONVERT(name,'AL32UTF8','EE8ISO8859P2') from table@remotedb" i get "Je┼×" selected into my primary database

Does anyboy know what I'm doing wrong?

Regards
Klaus Mogensen

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2009

Added on May 28 2009

5 comments

576 views