MySQL 4.1.14 --> 4.1.15 upgrade problem with encoding
Posted by:
jim huang
Date: October 27, 2005 12:50AM
Hi My system is base on FreeBSD5.4
I have first install the mysql 4.1.14 version by using port command
make WITH_CHARSET=utf8 WITH_XCHARSET=all SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes
make install
make clean
make rmconfig
then I install phpmyadmin by port
then I install my CMS site after I install everything that's necessary. such as Apaceh2 , ...etc
And I active my CMS site, look at the pages and everything works Good.
All chinese characters are display normally for few weeks.
Then I recently upgrade the MySQL from 4.1.14 to 4.1.15 by portupgrade
Then the nightmare starts.
This is command that I used.
portupgrade mysql-server-4.1.14
portupgrade mysql-client-4.1.14
then... the problem starts...
1) In the website's articles, all chinese characters that called from database are becomed ???
2) I checked the database by using phpmyadmin to browse the data, and all data displays CORRECT CHINESE.
3) I reinstall the CMS and create the new database with it. All Chinese characters inside the new database is unreadable by phpmyadmin, but it's readable by CMS.
4) I reinstall the database by
make deinstall clean rmconfig
make WITH_CHARSET=utf8 WITH_XCHARSET=all SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes
make install
make clean
Then I found that the result is the same as before, all Chinese becomes ??? with old database on the old CMS, and with new CMS, the data inside database is unreadable by phpmyadmin.
5) I checked the MySQL chaset by phpmyadmin and here is what it shows
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: UTF8_general_ci
I also try to change MYSQL connection collation to UTF8_unicode_ci but that makes no different with result.(Chinese still not readable with new database.)
MD-Pro è¨å®šèªªæ˜Ž --> This is what it shows on new database 4.1.15
MD-Pro 設定說明--> This is what it shows on the old database 4.1.14
I also try to create database in UTF8_unicode_ci and UTF8_general_ci but both has no difference with the result.
I checked my browser and it's selecting the UTF-8 encoding... So, I am losted..
So I don't know what should I check or change now..
Does anyone has some problem after upgrade?
This is what install into my machine
FreeBSD 5.4-RELEASE
Apache 2.0.55
Php 4.4.0
gd 2.0.33
perl-5.8.7
MySql 4.1.15
Subject
Views
Written By
Posted
MySQL 4.1.14 --> 4.1.15 upgrade problem with encoding
4417
October 27, 2005 12:50AM
2407
October 29, 2005 06:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.