Special Character un database column

NH_Talend — Tue, 04 Nov 2025 09:30:30 GMT

Hello Everyone,

I'm trying to insert data in table which some of column names contains this character £.

I get this error :

Exception in component tDBOutput_1 (JOB_NAME)
java.sql.SQLException: [SQL0104] El{ment syntaxique £ n'est pas correct. El{ments possibles : ) ,.
Im using AS400 database 
I activated Allow specific characters (UTF8,...) in File > Edit Project properties but it didn't work.
Can someone help please ??? 

Re: Special Character un database column

gvarun_arthasolutions — Sat, 29 Nov 2025 17:52:42 GMT

Hope this helps -
DB2 for i does not allow special characters like £, é, ê, @, spaces, etc. in unquoted identifiers.
So, when Talend generates SQL like:
INSERT INTO MYTABLE (AMOUNT£, OTHERCOL) VALUES (?, ?)
DB2 for i interprets £ as invalid syntax → SQL0104 (“Syntax element £ not valid”).
This has nothing to do with UTF-8 data.
The problem is your column name, not the data.

Quote every column name-
DB2 for i allows special characters only when the identifier is delimited with double quotes:
INSERT INTO MYTABLE ("AMOUNT£", "OTHERCOL") VALUES (?, ?)
How to force this in Talend
1. Open your tDBOutput
2. Under Advanced settings
3. Check "Use field table"
4. In the field table, manually enter your column names with double quotes, e.g.:
Schema column DB column
amountPound "AMOUNT£"
othercol "OTHERCOL"
This forces Talend to generate valid SQL.

topic Special Character un database column in Talend Studio

Special Character un database column

Re: Special Character un database column