national character set query question
hello group. i have looked through the nls related docs, but i still have a question.
i have these two tables:
create table test1 (col1 varchar2(50));
create table test2 (col1 nvarchar2(50));
if i do a:
select col1 from test1
union
select col1 from test2
i am presented with the infamous ORA-12704: character set mismatch
i have these two tables:
create table test1 (col1 varchar2(50));
create table test2 (col1 nvarchar2(50));
if i do a:
select col1 from test1
union
select col1 from test2
i am presented with the infamous ORA-12704: character set mismatch
0