Encoding issues with mysql "latin1" : Handling special characters
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? ()
