mysql 4.0.27 to 4.1.19 issues

[aykfounder]

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

 

[Shinichi Kato]

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

 

[aykfounder]

Alright, I'll give it a shot.

Thanks

 

[furquan]

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 ?