I am creating a local development environment for individuals.
When entering Japanese into xammp's MariaDB shell, the value of sex got garbled.
When I consulted the staff of MariaDB, they asked for a contract.
They taught countermeasures against garbled characters of phpmyadmin but phpmyadmin are slow in xammp.
I'd like to use shell because I want to enter it in the database.
I will describe the garbage countermeasure that they taught.
## UTF 8 Settings
init-connect=\'SET NAMES utf8\'
collation_server=utf8_unicode_ci
character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="C:/xampp/mysql/share/charsets"
It is garbled at the windows command prompt.
Please tell me the solution for garbled characters.
I think that xampp is good for personal local development.
Installation and uninstallation are easy.
It is easy to use with a mail server.
Where is a MariaDB specialized forum ?