The Community Forums

Interact with an entire community of cPanel & WHM users.
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql 4.0.27 to 4.1.19 issues

Discussion in 'General Discussion' started by aykfounder, Jun 30, 2006.

  1. aykfounder

    aykfounder Well-Known Member

    Joined:
    Feb 22, 2004
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    16
    Hello,

    I have a user who is using Chinese characters in UTF-8. He came from a 4.0.27 MySQL version to 4.1.19 and now they do not work. Instead the following error occurs:

    Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

    Any ideas on how to go about this will be greatly appreciated.

    Thank you
     
  2. Shinichi Kato

    Shinichi Kato Well-Known Member

    Joined:
    Mar 7, 2005
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Saitama-ken,japan
    Hi.
    Add the following options if you are root.

    Edit:MySQL configure file.
    vi /etc/my.cnf

    [mysqld]
    skip-character-set-client-handshake << Add
    default-character-set=YOUR LANGUAGE SET NAME << Add
     
  3. aykfounder

    aykfounder Well-Known Member

    Joined:
    Feb 22, 2004
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    16
    Alright, I'll give it a shot.

    Thanks
     
  4. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    425
    Likes Received:
    0
    Trophy Points:
    16
    character set messed up :(

    Hi ,

    I am having a similar issue.

    In most of our databases we use greek characters, as they are used in Greek sites, and in all those cases the excoding that was used was Greek ISO-8859-7.

    After the upgrade it seems like everyhting that was in Greek has been converted to somethign else - most likely utf8. It is now impossible to export any table that has Greek into it with the text being readable afterwards.

    Also it is impossible to import any db backup as it comes up garbled.

    Additionally even in phpmyadmin - under any combination of browser encoding and language setting of phpmyadmin, it is impossible to read greek character as they all now look like hyeroglyphs....

    Any help on this Pls ?
     
Loading...

Share This Page