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.
Thanks for your help in resolving this issue. We wrote a short article to address MariaDB with UTF-8 Character Sets and Collations.