Results 1 to 5 of 5

Threaded View

  1. #1
    Join Date
    Aug 2006
    Posts
    166
    Plugin Contributions
    2

    help question mysql utf8 re-import shows meaningless characters

    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
    Last edited by reza; 31 May 2007 at 09:56 AM.

 

 

Similar Threads

  1. v151 UTF8 Special Characters not coming thru in Meta Title/Description
    By Feznizzle in forum General Questions
    Replies: 4
    Last Post: 20 Oct 2015, 07:59 PM
  2. Replies: 2
    Last Post: 5 Jan 2015, 08:09 PM
  3. UTF8 and special characters after upgrade
    By aeolidia in forum Upgrading from 1.3.x to 1.3.9
    Replies: 6
    Last Post: 10 Apr 2011, 09:29 PM
  4. Problem with MySQL export with chinese and UTF8
    By gamenano in forum General Questions
    Replies: 0
    Last Post: 4 Nov 2010, 02:39 AM
  5. import export special characters
    By bikemike in forum General Questions
    Replies: 0
    Last Post: 26 Nov 2006, 04:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg