Phpmyadmin displays Japanese characters as a bunch of question marks even if I set the encoding and collation to utf8_unicode_ci
okee, I followed all the instructions I could find here
and I was able to display all kinds of multilingual characters on different pages ...
The problem is phpmyadmin, Japanese characters are replaced with question marks, like in a bunch ???? ???
. I think there is a problem with my database collation, but I just wanted to check it out here.
We had this database pre-set by default, which is equal latin_swedish_ci
and it already has a lot of data. Now we had to add some tables requiring special character support, so I definitely couldn't set the database mapping to utf8
. My solution was to utf8
only use for tables requiring this kind of support and for specific columns where we expected special characters to be contained.
But still phpmyadmin displayed them as ????
.
Another question I have is, will these fields be searchable? I mean, if a field contains some Japanese characters and I typed sayuri
in as a keyword, would the Japanese character be equivalent to their English-spoken syllables?
source to share
Mmm, as for your first question, do you have Japanese fonts installed on your system? They are not installed by default for most OSs, but I have no idea what your OS is. Next stupid, but your browser settings are OK?
The next question, the answer is no, if you search for ε ζ°Έ ε°ηΎε, it will not match Yoshinaga Sayuri.
Note. Can you see my Japanese characters?
source to share
The problem is that the connection setting is not set to utf-8 (most likely latin1) for which you need to display Japanese characters. You can install it manually by sending requests:
SET CHARACTER SET utf8;
SET NAMES utf8;
Or in the MySQL config file:
default-character-set=utf8
skip-character-set-client-handshake
source to share