I have setup zen cart 1.3.7.1, and have used the netstudio greek language pack for an English/Greek e-commerce site. I have used utf8_general_ci collation in the mysql database (local test site in Win XP sp3, with wamp server), and also have set the charset to utf8 in the code of the greek.php file. I decided to use utf-8 collation and not greek_general_ci because I might add a 3rd language in the future so I would like it to be supported.
I modified the corresponding lines in greek.php file of both the /includes and the /admin directories to (front-end and admin section):
Code:
@setlocale(LC_TIME, 'en_US.utf8');
and
Code:
define('CHARSET', 'utf-8');
Also I have modified the query_factory.php file in order to set the queries to utf8
Code:
mysql_query('SET NAMES "utf8"', $this->link);
I also added the greek language through the admin panel of zen cart.
When I run the cart, the pages are utf8 encoded (as I expected), in both the english and greek languages, but when I switch to the greek language, I get correct greek characters concerning output from the database (e.g. product description in greek) but wrong encoding characters concerning the greek translated menus in the side bar of the front-end (e.g. Όλα τα προϊόντα ...', 'Προχωρημένη Αναζήτηση' etc). Instead, I get boxes and symbols.
Now, when I switch he character encoding from the browser menu tto Greek-iso-8859-7, I get the greek data from the database wrong encoded (boxes and symbols), and the greek sidebar menu right (the reverse result).
I have gotten similar results by using the zen cart greek language pack add-on (for zen cart 1.3.7) (I did the same steps to utf8 encode the pages).
So, it seems that in each case, half of the greek output is ok and half is wrong encoded, although the whole page is utf8 encoded.
1. The netstudio greek pack is made for zen cart 1.3 Could that be a cause for my problem, since I use version 1.3.7.1 ?
2. Do you think that I should use greek_general_ci collation in the mysql database ?
3. If I did that, which pack should I use and which setting in the charset code of the greek.php file ?
4. If I used greek_general_ci collation, could that support a 3rd European language in the future ?
5. Also, is there a greek translation for the admin section yet ?
I really appreciate any help
Bookmarks