All Forums Database
ratu 8 posts Joined 10/09
26 Feb 2010
special characters

Hi, I have a dilemma…I have a table A that has some special characters in a column aa. When inserting into table B, the following SQL gives the untranslatable character errorInsert into B.bbselCASEWHEN A.aa IS NULLOR A.aa = ''THEN '*'ELSE A.aaEND AS A.aafrom AThe column DDL is VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFICIn both that A and B tables.However, If I skip this test and just insert the column A.aa as it is, I can do something like this later:Insert into B.bbsel A.aa from A ;update B.bbset B.bb = '*'where B.bb is null or B.bb = '';

meena 8 posts Joined 10/06
26 Feb 2010

hi, i could insert. please check in both source and target table it is specifed as CHARACTER SET LATIN NOT CASESPECIFIC.CREATE TABLE testa,FALLBACK,NO BEFORE JOURNAL,NO AFTER JOURNAL(col1 VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC, col2 VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC ) PRIMARY INDEX( col1 );CREATE TABLE testb,FALLBACK,NO BEFORE JOURNAL,NO AFTER JOURNAL(col1 VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC, col2 VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC ) PRIMARY INDEX( col1 );Insert into testbselCASEWHEN col1 IS NULLOR col1 = ' 'THEN '*'ELSE col1END AS DES,col2from testa;sel * from testa col1 col2 2 ab-inito 1 Teradata ? Oracle java SEL * FROM testb; col1 col2 2 ab-inito 1 Teradata * java * Oracle

ratu 8 posts Joined 10/09
26 Feb 2010

Hi Meena, thanks for your reply!The issue I am expreiencing is little different. I made sure that both source and target table has the column specified as VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC.I am able to do what you have doen. The issue arrises when we have some special characters which in my case was some russian symbols..I cannot reproduce the error now since we just corrected the data at source.Thanks though! :-)

You must sign in to leave a comment.