Start a new topic

*SOLVED* Collation diacritical (accent) characters not displaying properly

We are using latin1_spanish_ci collation for latin1 character set with utf-8 encoding in our MariaDB.


In DbVisualizer, with MariaDB jdbc connector, all of the Spanish characters with diacritical (accent) marks were displaying like this �, �, �, �, �, �, �, �, �, �


Evidently, the MariaDB jdbc connector does not fully support specifying collation at this time.


I switched to the mySQL jdbc connector and set the driver property connectionCollation = latin1_spanish_ci. Same problem.


It was not until I also set the driver property characterEncoding = utf-8 that the Spanish characters with diacritical (accent) marks displayed correctly like this ü, é, á, í, ó, ú, ñ, Ñ, ¿, ¡


I have attached screen shots to illustrate the problem and solution.


If anyone else is experiencing this problem, I hope this will help.






1 Comment

Hi Martie,


Thanks for your help in resolving this issue. We wrote a short article to address MariaDB with UTF-8 Character Sets and Collations.


Regards

Peer




Login or Signup to post a comment