How to fix ORA-12704: character set mismatch
753689Feb 14 2010 — edited Oct 19 2010I am newish to oracle and am trying to work out why the following doesn't work:
create table utest(test nvarchar2(100));
insert into utest values('fish');
select test from utest union select '' from utest;
I need to be able to do a union on a table with an nvarchar2 fields, where on union, some of the columns are simply ''.
Not quite sure how to work out which oracle version exactly this is, we are given remote access via JDBC.