1

the source character is "in check" which one of our app users added, and i can't figure out what it is actually.

i used way of this link ("Incorrect string value" when trying to insert UTF-8 into MySQL via JDBC?) to solve the problem when i insert special characters into mysql via jdbc.

but when sql exception ws gone, i find my characters inserted into mysql are like this "? in check"

can anybody help me slove this problem? thanks

Community
  • 1
  • 1
user2605926
  • 21
  • 3
  • Where do you see the output with question mark? Use the `HEX` function to confirm that the column actually stores a question mark and it's not just that the client software decides not to show it. – Joni Jul 22 '13 at 13:57
  • actually the column stores something else when imported via jdbc , but i can't store it correctly in mysql. so how can i solve this problem? – user2605926 Jul 23 '13 at 01:40
  • What is that something else that the database stores? – Joni Jul 23 '13 at 05:43
  • "in check" this is the data i got from cassandra, and this is a ugc, so i cannot exactly know "". My task is to store this user data into mysql without change. – user2605926 Jul 23 '13 at 06:01
  • What does ugc mean? What happens when you store this string in MySQL, what is actually stored in the column? If you're asking what that character is, it's an emoji for a bag of money – Joni Jul 23 '13 at 06:24

0 Answers0