Japanese text outputs Question Marks

I have just completed our Japanese cart on my local testing environment using zen-cart-v1.3.0.2-l10n-jp-4.

Everying is working fine.

Japanese is displaying correctly.

I have then moved everything to our live site and made a database and imported the mysql that I dumped from our testing environment.

Japanese is now displayed as question marks.
Non database HTML Japanese is displaying correctly.

If I check my database through phpmyadmin on my live site all japanese is displaying correctly.

My character set are as follows.
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8

The funny thing is if I do a freash install of 1.3.0.2-l10n-jp-4 and use the sample data on my live site all Japanese displays correctly.

It seems to be somthing to do with phpmyadmin not importing my database correctly into the live site.

It is running MySQL 5.0
phpMyAdmin 2.11.9.2
PHP Version 5.2.6

I have been at this for days now and it is driving me nuts.
Please help.........

Please try to add following line at top of the sql file exported from old web site.

set names ujis;

Hello Shida,

Whe I do that I get

Error

SQL query:

SET NAMES ujis;

MySQL said: Documentation
#1115 - Unknown character set: 'ujis'

please try

set names latin1;

or

set names utf8;

Still no good Shida

I noticed my live enviroment doesn't have Japaneses Character Sets and Collations but my testing server does. I have emailed the live site admin and asked them to add.

cp932_bin
cp932_japanese_ci
sjis_bin
sjis_japanese_ci
ujis_bin
ujis_japanese_ci

Fingers crossed that is what my problem is....

I am still having no luck. I restored the database using the

BACKUP MYSQL ADMIN PLUGIN 1.3

and text is now garbeled not question marks. I then set the browsers Encoding to UTF8 and I can see the database driven japanese but not the non database html.

Anyone got any ideas??

Just to update this, I am now helping him on this now. Somehow, don't ask me, but through using settings on his local server, he had a mix of UTF and EUC encoding. When he went to move it over to his online server, it came up with mixed encoding. This is kind of good as we are going to try and just take the database and upgrade it to 1.3.8 and use a UTF-8 Japanese Pack that I made and a UTF-8 cart.

Just to update this. This has now been fixed. Converted the cart over to my Japanese Pack. It was also a great opportunity to really go through and setup the next release of the Japanese Pack. Think I should have it out soon.

I am about to set up a store using zen cart 1.3.8. I want to launch it in English first since tranlation into Japanese and other types of research related to the Japenese site will take some time, but I would like to start to build the Japanese mirror site already now, and then add it when I am ready.

So since I am setting it up afresh, I suppose I could use UTF-8 coding from the start. Are there any cons?

Any news on the new Japanese Pack?

Tx

Hi Eple,

Any cons to UTF-8, no, it's way better if you plan to run Japanese.

The new Japanese Pack. I am not sure yet when I can get it out. I have it, just don't have the documentation for it. There is no real ETA for it right now. You can contact me if you want me to install it on your site or you can wait for it to come out. Just busy with my current workload.

Regards,

CKD