I am making a database of Japanese-English vocabulary.
At first I could not get the multi-byte characters I was writing to the database to display properly from my php script. Then I found this article (http://www.phpworld.com/manual2003/ref.mbstring.html ) which clearly explains how to modify the php.ini file so that multi-byte characters will display.
I made the modifications as detailed there for users of 'SJIS' (shift_jis) encoding. Now a lot of characters display properly but there are still some which end up corrupted.
In phpAdmin when I browse the contents of the MySQL table in question, all the japanese characters appear garbled, but my php script does , as I stated just now, display most of them correctly.
Can anyone with experience of multi-byte characters in php and MySQL (in particular japanese shift_jis) give me any pointers as to how to make sure that all characters display correctly.
I should add that I am using a japanese os and that all the relevant character sets are properly installed.
I am not clear now whether the problem is with my php.ini settings or with MySQL.
