special characters

Tools
Enthusiast

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 error

Insert into B.bb
sel
CASE
WHEN A.aa IS NULL
OR A.aa = ''
THEN '*'
ELSE A.aa
END AS A.aa
from A

The column DDL is VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC

In 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.bb
sel A.aa from A ;

update B.bb
set B.bb = '*'
where B.bb is null or B.bb = '';