Database Administration (MOSC)

MOSC Banner

national character set query question

edited Mar 3, 2009 7:00AM in Database Administration (MOSC) 4 commentsAnswered
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

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