how to get utf8 data to nvarchar colums of an iso db?
Dear experts!
I have got to databases - one with UTF8 and the other with ISO8859P1 characterset.
In the UTF8 DB I have a test table containing utf8 data:
create table text (c1 varchar2(100));
insert into text values ('Abkürzung für Česká zbrojovka test');
In the ISO DB I have the following table:
create table text (c1 nvarchar2(200));
I also created a database link from the ISO to the UTF8 DB and did the following insert:
insert into text select c1 from text@utf8db;
But on selecting from the ISO table I get the following result:
Abkürzung für ¿eská zbrojovka test
So what is going wrong here?
Thanks
Markus