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

[pilou2]

I forgot this one is important too, check it please:
define('CHARSET', 'utf-8');

[nurapipi]

Hi,
Thank you all for your response.
I did things suggested but it doesn't work.

@lazy_666
I changed query_factory.php as I posted previously, is there any other code should be changed?

@CrystalKoi
I installed a fresh Zencart but the problem is still there.
My collation settings is utf8_general_ci. I changed collation to "utf8_general_ci" from phpMyAdmin->Operations befrore I install a fresh Zencart.

@pilou2
I transferred my cart from UNIX system to another UNIX so it should be OK. And "define('CHARSET', 'utf-8');" is OK, too.

As I mentioned, if I insert data from phpMyAdmin, it can be dispalyed correctly both on phpMyAdmin and Zencart, but if I input data from Zencart, it cannot be displayed correctly.
It seems that phpMyAdmin(or MySQL!?) can pass the correct character code to Zencart, but Zencart cannot pass correct character code to phpMyAdmin(or MySQL!?).
phpMyAdmin(send) -> (receive)Zencart (O)
Zencart(send) -> (receive)phpMyAdmin (X)
so the problem happens only when Zentcart tries to insert data into MySQL. Is that possible problem of my new server's setting? Thanks again.

[Mikado]

I have a problem with french language.


In phpMyAdmin, the collation is : utf8_unicode_ci
Jeu de caractères pour MySQL: UTF-8 Unicode (utf8)

In includes/languages/french.php :

@setlocale(LC_TIME, 'fr', 'french', 'fra', 'fr_FR', 'fr_FR@euro');
define('HTML_PARAMS','dir="ltr" lang="fr"');
define('CHARSET', 'utf-8');

In admin/includes/languages/french.php :

@setlocale(LC_TIME, 'fr', 'french', 'fra', 'fr_FR', 'fr_FR@euro');
define('HTML_PARAMS','dir="ltr" lang="fr"');
define('CHARSET', 'utf-8');

In page source of index.php :
Character Encoding-> UTF-8
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">


In page source of admin/index.php :
Character Encoding-> iso-8859-1
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Does any one know what could be the reason of this issue?

[nurapipi]

Hello,

Try this:
Go to your Zencart admin page,
Tools -> Developer Tool Kit
and search "iso-8859-1" from "look-up in all files" and check did you change all "iso-8859-1" to "UTF-8".

Good luck.

I have a problem with french language.


In phpMyAdmin, the collation is : utf8_unicode_ci
Jeu de caractères pour MySQL: UTF-8 Unicode (utf8)

In includes/languages/french.php :

@setlocale(LC_TIME, 'fr', 'french', 'fra', 'fr_FR', 'fr_FR@euro');
define('HTML_PARAMS','dir="ltr" lang="fr"');
define('CHARSET', 'utf-8');

In admin/includes/languages/french.php :

@setlocale(LC_TIME, 'fr', 'french', 'fra', 'fr_FR', 'fr_FR@euro');
define('HTML_PARAMS','dir="ltr" lang="fr"');
define('CHARSET', 'utf-8');

In page source of index.php :
Character Encoding-> UTF-8
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">


In page source of admin/index.php :
Character Encoding-> iso-8859-1
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Does any one know what could be the reason of this issue?

[CrystalKoi]

I just did an install of this. I had to update one thing on the instructions. Changed the location of the language file for the Admin. I'm sure most people got that anyways.

I fallowed my instructions to see if I would get any problems, and all is fine.

Sorry and Good luck,

CKD

[nurapipi]

Hi

I resolved my problem by changing my server provider. So my issue was nothing to do with Zencart or MySQL. Sorry to confuse you all and thanks for your advices.

[yonghs]

I think I have a couple of issues related to language encoding.. this seems the proper thread to ask.


I have English Zen Cart installed and then added the Simplified Chinese language pack, GB2312. Adding/viewing Chinese thru web browser is fine (product desc, categories etc)

But found a couple of issues :

1. The order confirmation (Chinese) text-email sent out can't display the product name (the line with the quantity /product name / product code). It shows something like:
1 x Ĉ 21; 421;Ŏ 57;È 04; 359;# 033; (AA3319) = $25.00

Other parts of the email shows chinese just fine.

2. The search function doesn't return any results if I search with chinese words (in chinese mode)

Bcos the database is in ISO-8859??

Is there anyway to rectify without reinstalling. Just by changing the encoding of the database?

Thanks.

[gleb486]

Hello! I need help please. I use ZC in two languages English and Russian. I've defined the charsets in both english.php and russian.php as UTF-8. I have converted all Rusian PHP files from ANSI to UTF-8 without BOM. I have then changed all database tables colladion to utf_general_ci. I have no problems with characters displaing but when I perform search in search engine in Russian it comes with no result. The search browser doesn't see anuthing in Russian. Can anybody help me please? Where is the problem?

[radkish]

Hi, I have a problem with the search in my zen-car when I use UTF-8 encoding
My database is in collation utf8, charset in bulgarian.php and in english.php is utf-8 too.My DB/tables are utf8 but I can make search when type cyrillic words. It shows no results. With English word everything is OK:)
Can somebody help me?!

[oschellas]

See forums.oscommerce.com/index.php?showtopic=262287 for a possible solution?