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

Thanks!

:)

I set UTF-8 end i have o.k. character. But in Opera end IE the font is different (bigger) in Firefox font is good.
Hay it's possible!

kobra8:

I set UTF-8 end i have o.k. character. But in Opera end IE the font is different (bigger) in Firefox font is good.
Hay it's possible!

With http://validator.w3.org while checking this document as XHTML 1.0 Transitional faund:
The Unicode Byte-Order Mark (BOM) in UTF-8 encoded files is known to cause
problems for some text editors and older browsers. You may want to consider
avoiding its use until it is better supported.

Is thet problem with font in IE, Opera end Firefox?

Font size is part of css. Note the part where it says, Older text editors and browsers. Anything above IE6, you will have no problem with UTF-8.

With font, you need to adjust your css.

Regards,

CKD

Thanks for the instructions. I have followed the steps (modify the php files) except that I use MySQL Administrator UI to change the default collation to utf8_general_ci. Restart the MySQL Service, create the database.

When trying to install Zen Cart, I got this error:

Installation In Progress...

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ 

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ 

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ 
1366 Incorrect string value: '\xA3:&eur...' for column 'configuration_value' at row 1
in:
[INSERT INTO szc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '£,£:€,€', 'What currency conversions do you need for Text emails?
Default = £,£:€,€', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');]

I am not sure what I am missing here. Could you give a hint?

Thanks!

That's because the .sql file containing the initial database load in v1.3.x contains several non-UTF-8 characters in it, and you've set your database to be UTF8.

Hi everyone,

I've installed a 1.3.8a ZC recently, and am having trouble with the UTF8. This is not the 1st time I work on Chinese ZC stores, but it's been years since the last install so I can't remember what I did to get the other stores working...

I've followed the instructions here : http://www.srw2d.com/content/utf-8-zen-cart

But when I tried to edit the query_factory.php file I ran into a problem.

Here is a rundown of what happened :

1. Installed ZC 1.3.8a and the traditional Chinese language pack (I forgot to do the recommended changes before installation).
2. After the store and Chinese language are both installed and working, I went ahead and did the changes as per instructions at srw2d.com.
3. After I edited query_factory.php I got a blank page at my store.

Current store settings :

1. MySQL connection collation is utf8_unicode_ci
2. My ZC database collation is utf8_general_ci
3. Everything looks fine at the shop and admin
4. All Chinese characters became "aliens" in the database
5. If I edit the database fields directly, I can read the Chinese characters in the database but they become "aliens" at the front end

I hope I don't have to start the whole thing over... any help would be much appreciated ! Thanks in advance ! :)

Shirley

shirster:

3. After I edited query_factory.php I got a blank page at my store.
   Using the Debug Log utility from this article should help you find what's causing the blank page: https://www.zen-cart.com/tutorials/index.php?article=82

I will try and post the file on my site so that you can download it and use it.

I have seen this issue before with people. But can never work out why. On Monday, here in Japan, I will post a file to the srw2d.com site and put a link here to download it. You can try that file and see if you still have the same problem.

Regards,

CKD

Thanks Dr. Byte and Koi. I haven't tried the debug utility yet, I'd just like to report that if I edit the query_factory.php file BEFORE installation, I couldn't even install, I simply got stuck at the install page.

But if I proceed to install without editing the query_factory.php file, I got alien characters in the database again.

:SIGH:

I attached one file that I know works here:
Attachment #6324

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

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^)/

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.

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.

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?

@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.

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?

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.

@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!

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..
https://www.pilica.si

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