Japanese is garbled with MariaDB

python.kotaro 2019-01-11 10:47:20 UTC #1

I installed xampp. I faced trouble when using MariaDB.
Japanese is garbled with MariaDB in windows environment.
Please tell me the setting so that Japanese is not garbled in the MariaDB shell.

jota 2019-01-11 12:51:20 UTC #2

Hi @python.kotaro,

Thank you for using XAMPP. We use utf8_general_ci as default character set when configuring MariaDB. You will need to set the proper charset in the MariaDB's configuration file and restart the server for the changes to take effect. You can obtain more information about the different charsets here

https://mariadb.com/kb/en/library/supported-character-sets-and-collations/

Happy to help!

Was my answer helpful? Click on

python.kotaro 2019-01-11 20:05:40 UTC #3

Please tell us how to set the proper charset in the MariaDB's configuration file.
When I research setting proper charset, I see so many information about that Japanese is garbled with MariaDB on internet. But I couldn't fix it. do you have any Japanese staff ?

jota 2019-01-14 10:39:06 UTC #4

Hi @python.kotaro,

I just reviewed this and found that the utf8 charset is the best one to use with the database

https://stackoverflow.com/questions/1045338/which-is-the-best-character-encoding-for-japanese-language-for-db-php-and-html

If you want to try other charsets, you can edit the installdir/mysql/bin/my.ini file and set the charset you prefer.

Sorry but we don't have any person from Japan in the company.

Thanks

python.kotaro 2019-01-14 12:03:33 UTC #5

thanks.
But I'm talking about that Japanese is garbled with MariaDB command prompt of windows10.
if xampp company know how to fix it, please tell us.

jota 2019-01-15 11:14:23 UTC #6

Hi @python.kotaro,

It'd be great if you post your question in a MariaDB specialized forum, you will probably find more information there. However, we would like to know more about the issue, could you please elaborate it more so we can take a look at it? What are you trying to achieve? Can you share a screenshot?

Thanks

python.kotaro 2019-01-15 17:37:45 UTC #7

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 ?

jsalmeron 2019-01-18 08:14:40 UTC #8

Hi,

Did you try asking in the ApacheFriends forum? https://community.apachefriends.org/f/viewforum.php?f=7

It is an active XAMPP community

Hope it helps

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!