1

I have following problem: When I try to insert a String like "SPRÜCHEթ.txt", it throws an error like: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBDCHE...' for column 'comment' at row 1

I have read that these UTF-8 4 byte String characters are supported with mysql 5.5, but I am not able to update the database (there is no webmin update function?)

how can I achieve inserting those complex characters?

Niko
  • 1,054
  • 5
  • 25
  • 52
  • pls check http://stackoverflow.com/questions/8433293/how-can-i-insert-arabic-word-to-mysql-database-using-java – bgth Apr 11 '14 at 18:44
  • i have checked it... it is useUnicode=true or useUnicode=yes? I have read different things... so it should work with mysql 5.1? – Niko Apr 11 '14 at 18:51
  • jdbc:mysql://localhost:3306/?useUnicode=yes&characterEncoding=UTF-8 – bgth Apr 11 '14 at 18:57
  • You can always loop through the string, look at each char, and if the code is > 128, change it to the HTML entity `code;` – developerwjk Apr 11 '14 at 19:20

0 Answers0