UTF-8 Zen-Cart Tutorial for v1.3.x

[CrystalKoi]

I attached one file that I know works here:
query_factory.zip

Upload this one to includes/classes/db/mysql/

This overwrites the core file.

Let me know if you still get the error after this,

Regards,

Shaun


NOTE:
With v1.3.9 you don't have to touch the query_factory.php file.
You should use this method instead: http://www.zen-cart.com/forum/showthread.php?t=153582

[shirster]

Shaun... YOU SAVE MY LIFE !!!!!!!!!!!! It works now ! (Though I used BBEdit to compare the documents and still don't know what went wrong ^^)

Arigato !!!!!!!!!!!!!!! \(^o^)/

[CrystalKoi]

Nice to hear.

Wonder what the problem is? Maybe you can attach your file and I can look at it, or the Dr. if he has time.

[e81ny]

Hi,

After installed, when I switch from English to Japanese in Admin, I got this message on the top of the page:

Warning: Cannot modify header information - headers already sent by (output started at /homepages/24/d293486072/htdocs/GooGooNY/includes/languages/japanese.php:2) in /homepages/24/d293486072/htdocs/GooGooNY/includes/init_includes/init_templates.php on line 36

Also, everything I input in Japanese for product or EZ Pages, they all come out like this: "????????"

What have I done wrong? I'm pretty sure I followed every step correctly..

Please help! Thanks.

[e81ny]

Hello,

Everything is good now; I've found the reason why the Japanese wasn't displayed correctly.

But I still have problem with the admin panel. Everytime when I switch from English to Japanese, it doesn't pick up that it is UTF-8 even though it IS UTF-8 according to the source code. It always uses other language coding and of course, the text just cannot be read. What's more annoying is that every page you go (in admin area), I have to change the code to UTF-8 manually everytime...

What should I do?

[yellow1912]

@CrystalKoi: I have written a script that will automatically convert all appropriate zen table fields to utf8. If this works with no problem it would be great for running stores. I will keep you updated.

[CrystalKoi]

Hello,

Everything is good now; I've found the reason why the Japanese wasn't displayed correctly.

But I still have problem with the admin panel. Everytime when I switch from English to Japanese, it doesn't pick up that it is UTF-8 even though it IS UTF-8 according to the source code. It always uses other language coding and of course, the text just cannot be read. What's more annoying is that every page you go (in admin area), I have to change the code to UTF-8 manually everytime...

What should I do?

Sorry for the late reply here. Go into your admin language file. admin/includes/japanese.php and look for where it says

define('CHARSET', 'utf8'); 

change that to :

define('CHARSET', 'utf-8'); 

Sorry about that, its a known issue. FF handles it fine, but IE does not.

[CrystalKoi]

@yellow1912 - you might want to contact Dr. Byte as I know he is trying to work this into the install for 2.0. Maybe it could be some help to him. It would be a great tool for the community!

[Spiritus]

Hi there..
I'm having problems with my site..
I followed steps from CrystalKoi, but characters are not ok..


But there is one thing I must say...
I'm switching server for my store!
After fresh install of new one I made a collation in database to utf8_general_ci, then I import SQL database backup from old store.
And then collation changes to latin1_swedish_ci, I don't know why..
In my language pack is everything changed to utf-8.

When I change query_factory file is result even worser..
Can anyone help me please...

Here is my site..
www.pilica.si

[CrystalKoi]

Hi Spiritus,

The database you importing, that data is stored in latin1_swedish_ci I am guessing, no?

And if you change the collation, yes it will get worse if you don't have your information in UTF-8.

Check the database you are importing.

Regards,

CKD