1 Attachment(s)
Re: UTF-8 Zen-Cart Tutorial
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
Re: UTF-8 Zen-Cart Tutorial
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^)/
Re: UTF-8 Zen-Cart Tutorial
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.
Re: UTF-8 Zen-Cart Tutorial
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.
Re: UTF-8 Zen-Cart Tutorial
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?
Re: UTF-8 Zen-Cart Tutorial
@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.
Re: UTF-8 Zen-Cart Tutorial
Quote:
Originally Posted by
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
PHP Code:
define('CHARSET', 'utf8');
change that to :
PHP Code:
define('CHARSET', 'utf-8');
Sorry about that, its a known issue. FF handles it fine, but IE does not.
Re: UTF-8 Zen-Cart Tutorial
@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!
Re: UTF-8 Zen-Cart Tutorial
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
Re: UTF-8 Zen-Cart Tutorial
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