Character encoding between java and MySQL

Asked Aug 29 '17 at 08:45

Active Aug 29 '17 at 08:45

Viewed 38 times

I have a problem while inserting data from java jdbc to MySQL database, from a generated .jar file.

"Ñ" characters turns '?' in the table.

Things I tried without good results:

Adding useUnicode=yes&characterEncoding=utf8 in drivermanager URL
Changing character set to utf8 anD collation to utf8_unicode_ci

When I run the program in Eclipse IDE with ISO-8859-1 configuration works OK and put the correct characters into database, but when I run the .jar file in my system (Ubuntu 16 with UTF-8), '?' characters appears instead of 'Ñ'in the MySQL database.

Is there any solution? (I know is possible that this question will be a duplicated question, but other questions I found they haven't worked for me)

asked Aug 29 '17 at 08:45

SirGuacamole

What MySQL client are you using? – shmosel Aug 29 '17 at 08:48
Are you indeed offering "Ñ" to the database? If you read the text from file, that file should be read with (my guess) ISO-8859-1 (or better Cp1252). I think a file/resource is read with the default encoding, and a placeholder turned into a question mark. – Joop Eggen Aug 29 '17 at 08:53
shmosel I'm using MySQL WorkBench and MySQL version is 14.14 – SirGuacamole Aug 29 '17 at 09:00
Joop Eggen, I'm reading teh data from another database (using select and then putting the resultset into an insert into statement) – SirGuacamole Aug 29 '17 at 09:02
Joop Eggen If I put a 'Ñ' letter directly in the table it's appears OK – SirGuacamole Aug 29 '17 at 09:12
1

@JohnStonecutter - If you run your jar file with `java -Dfile.encoding=ISO-8859-1 -jar your.jar` does it work any better? (p.s. Remember to use "@" when you reply like I just did.) – Gord Thompson Aug 29 '17 at 12:03
1

See "question mark" in http://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James Aug 30 '17 at 01:34
Thanks @Rick James – SirGuacamole Aug 30 '17 at 07:13

Character encoding between java and MySQL

0 Answers0