Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Jan 2003 @ 13:38:58 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Error 6706: Untranslatable Character
 
From:   Claybourne Barrineau

All,

If I run the following query:

 Select  '' (char(24)) as Cst_Cb_Cd,
  '' (char(60)) as Cst_Cb_Nm,
  rcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  rcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  rcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  rcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  rcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  rcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFRE2IBET.t_dim_ret_cst rcst

 Union

 Select  vcst.Cst_Cb_Cd (char(24)) as Cst_Cb_Cd,
  vcst.Cst_Cb_Nm (char(60)) as Cst_Cb_Nm,
  vcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  vcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  vcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  vcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  vcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  vcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFVO4IBET.t_dim_vol_cst vcst

I get Error 6706 'The string contains an untranslatable character.'

However, if I switch the Union around:

 Select  vcst.Cst_Cb_Cd (char(24)) as Cst_Cb_Cd,
  vcst.Cst_Cb_Nm (char(60)) as Cst_Cb_Nm,
  vcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  vcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  vcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  vcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  vcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  vcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFVO4IBET.t_dim_vol_cst vcst

 Union

 Select  '' (char(24)) as Cst_Cb_Cd,
  '' (char(60)) as Cst_Cb_Nm,
  rcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  rcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  rcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  rcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  rcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  rcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFRE2IBET.t_dim_ret_cst rcst

I do not get the error.

I've narrowed the problem down to the Cst_Cb_Cd Column in the INFVO4IBET.T_DIM_VOL_CST table. This column is defined as:

'CST_CB_CD VARCHAR(24) CHARACTER SET LATIN CASESPECIFIC NOT NULL'

I ran the Translate_Chk function on Cst_Cb_Cd Using Latin_To_Unicode and Unicode_to_Latin, and I didn't get any errors. I'm completely baffled. Has anyone seen this problem before?


Thanks,

Clay



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016