Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
Collation Connection: sjis_japanese_ci
Server Collation: ujis_japanese_ci
Collation Database: ujis_japanese_ci
I import the data into a table in Shift_JIS format (sjis), After importing the data everything looks fine when viewing through phpmyadmin (the Japanese characters look fine with the browser encoding set to Japanese Shift_JIS), but when I do queries on the database through php in my php applications, the data returned from queries is always returned as Japanese (EUC), and won't display correctly with the browser having Shift_JIS encoding.
I think this is because of the above Server Collation and Collation Databse settings which are using the EUC character sets (ujis_japanese_ci).
Has anyone experienced something like this? Is there a way that I can change the Server Collation and Collation Database to sjis_japanese_ci if this is a shared MySQL database, or is there some other way to be able to display the characters as Shift_JIS?