How to save the special characters into a MySQL database using a Java application?

Question

I tried to save these special characters:

© ™ ® ± ≠ ≤ ≥ ≅ ∞ µ α β Ω Σ Φ φ <> ° & %

into a MySQL databuse using a Java application, but its not working.

While implementing the JDBC driver into my application, I made sure to do it this way:

 jdbc:mysql://ip:3306/db?useUnicode=true&characterEncode=UTF-8

but it's still not working. Instead, most of the characters are just transformed into question marks (?) like shown in the screenshot below:

My Screenshot

Answer 1

Change the URL to jdbc:mysql://ip:3306/db?useUnicode=true&characterEncoding=UTF-8

Error:

Use characterEncoding instead of characterEncode

Answer 2

Try this

String characters = "© ™ ® ± ≠ ≤ ≥ ≅  something";
String noCharacters = characters.trim();