Encoding issues with mysql "latin1" : Handling special characters

[Anonymous]

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.