All Forums Tools
ratu 8 posts Joined 10/09
25 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.bb sel CASE WHEN A.aa IS NULL OR A.aa = '' THEN '*' ELSE A.aa END AS A.aa from 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 = '';

You must sign in to leave a comment.