Re: screwed non-us7ascii characters while selecting from a database link

From: Geoff Muldoon <>
Date: Fri, 11 Jan 2008 21:41:08 +1100
Message-ID: <>

codadilupo says...

> db1: Oracle with charset WE8ISO8859P1
> db2: Oracle with charset AL32UTF8

> My problem is that if, in db1, I "insert into table select * from
> table_at_db1_link" the non-us7ascii characters are screwed, if I exp tables
> from db1 and imp them into db2 the characters are converted correcly.
> I'm checking the results both from Linux shell and mod_plsql webapp, so
> it's not a client issue.
> Any suggestion? Am I missing something?

EXP does smart things that dblink cannot?

IIRC, dblinks by default expect compatibility in NLS settings and may not handle character set conversion on the fly all that well.

GM Received on Fri Jan 11 2008 - 04:41:08 CST

Original text of this message