Encoding issues with mysql "latin1" : Handling special characters

Anonymous — Sat, 16 Nov 2024 02:28:18 GMT

Hi All ,

This is regarding an error I get with relation to inserting string values that have "international" characters used in them to a DB,

I get the below error while i'm trying to insert records from an excel sheet to a mysql database "java.sql.SQLException: Incorrect string value: '\xCC\x88zlem...' for column".

The excel sheet has rows where in certain columns I have string values such as 'John Nützenadel'

(note the international character for "ü" in the above mentioned string)

The database is MySQL and with the CHARSET=latin1. Changing this CHARSET value in the DB is not an option for me.

I want to know if there is anyway I can still insert these records into the DB as is?, or converting the international characters so that it can be saved in the DB? ()

I have attached a screen shot as well.

topic Encoding issues with mysql "latin1" : Handling special characters in Talend Studio

Encoding issues with mysql "latin1" : Handling special characters