Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ora 12704 - character set mismatch when select nvarchar2 column

ora 12704 - character set mismatch when select nvarchar2 column

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Thu, 26 Jul 2001 08:44:09 -0700
Message-ID: <F001.003561E4.20010726090047@fatcity.com>

Hi,
I have a table t_base_props with 3 columns defined as NVARCHAR2(256).......<FONT color=#0000ff face=Arial>
 When i try to select
directly from table like select nm_display_name from t_base_props.......the query is properly executed....
but when i try to use ncarchar2 columns in follwing query i am getting error ORA-12704: CHARACTER SET MISMATCH: What might be the reason.....
character set of database is WE8IS08859P1..... select
t_sub.id_sub,
map.id_po,map.id_pi_instance,map.id_paramtable, decode(tb_ip.id_prop,NULL,
tb.nm_display_name,tb_ip.nm_display_name) as

instance_nm_name,tb_pt.nm_name pt_nm_name,
tb_po.nm_name po_nm_name,
tb_po.nm_display_name po_nm_display_name,
decode(map.id_sub,null,'N','Y') as b_PersonalRate, map.b_canICB
from t_base_props tb,t_base_props tb_pt,t_base_props tb_po,t_effectivedate te,
t_pi_template,t_sub,t_pl_map map,t_base_props tb_ip where t_sub.id_acc = 123
and map.id_po = t_sub.id_po
and tb_ip.id_prop = map.id_pi_instance_parent(+) and
(map.id_sub is NULL or map.id_sub = t_sub.id_sub and map.id_acc = 123) AND
tb.id_prop = map.id_pi_instance AND
tb_pt.id_prop = map.id_paramtable AND
tb_po.id_prop = map.id_po AND

t_pi_template.id_template = map.id_pi_template AND te.id_eff_date = t_sub.id_eff_date AND
((te.dt_start <= GetUTCDate() AND (GetUTCDate() <= te.dt_end or te.dt_end is null))
OR (GetUTCDate() <= te.dt_start));
Thanks
Harvinder Received on Thu Jul 26 2001 - 10:44:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US