Hi
I have installed a fresh zen 1.3.7 with eeasy populate module.
I set colation to utf8-general-ci, because I use arabic and persian characters
I can add all my words in persian and arabic letters into the admin, and they are shows without problem in admin and frontshop.
I can also backup, export and agin import the this database and again works good, but when I export database, the not english characters (so pers and arab) are only some symboles.
these are server info:
Linux
Service Status Click to View
Kernel version 2.6.9-42.0.3.ELsmp
Machine Type i686
Apache version 1.3.37 (Unix)
PERL version 5.8.7
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.4.4
MySQL version 4.1.21-standard
cPanel Build 10.9.0-RELEASE 10737
Theme cPanel X v2.6.0
Documentation Click to View
cPanel Pro 1.0 (RC36)
-----------
now the problem:
1- when I try to edit this database (for exp. with excel tab-delimited after importing with easy populate, or even edit in notepad or notapad++ and saving in utf8 without bom, utf8, asni , etc, )non of them give me the desired result, it means that all the data that I have edited outside of admin area on the database, and are in non english characters, after importing the database with phpmyadmin, or admin/patch of zen, are shows now in meaningless characters, and mostly so: ????? ????? ??
2- is there any suggestion to use another conection collation in my phpmyadmin than utf8-general-ci for persian language, because I saw utf-persian-ci too, but I didn't want to limit me only to persian so I choosed utf8-general-ci.
can somebody help me, because with this history easy populate etc don't have any sense for my shop.
thanks
Bookmarks