Looking at the O ' Reilly Upgrading to PHP (as now mainstream development language) 5, the whim of the MySQL (and PHP collocation of the best combination) to upgrade to 4.1.11, because there is no formal system on the machine, there is no notice of its character set changes. Later on the formal application of the system also to upgrade, after the upgrade of other systems are no problem, but a mantis have trouble, open the page has become garbled, thanks to a backup can be restored, in the process of recovery found MySQL (and PHP collocation of the best combination) Upgrade brings the problem of the character set-if MySQL (and PHP collocation of the best combination) with the UTF8 character set, Mantis data import, the page is garbled, but only MySQL (and PHP collocation of the best combination) tune to the GBK character set.
In fact, I would like to use the UTF8 character set, because there is no incompatibility of the trouble, as a long-term retention of data, in the future to convert, tidy up more convenient, when the data exchange with the external, there is no encoding conversion problem. But I still do not understand, in the use of PHP (as the current mainstream development language) to connect MySQL (and PHP collocation of the best combination) to receive user input data, and in the database, if the database encoding is UTF8, whether to convert SQL data to UTF8? Take the time to get a small program to try, if it is so much trouble, but I am under DOS with command line operation UTF8 Character set MySQL (and PHP collocation of the best combination) server is not able to input Chinese characters.
The previous use of Sybase has been plagued by character set problems for a long time, because Sybase if the character set is wrong, some Chinese characters can not be input, such as uppercase 0 "0", so the character set from Iso_1 to cp850, and from cp850 to cp936, There's a lot of historical data left in the middle, MySQL (and the best combination of PHP) don't make me repeat it.
http://www.bkjia.com/PHPjc/508663.html www.bkjia.com true http://www.bkjia.com/PHPjc/508663.html techarticle looking at the O ' Reilly Upgrading to PHP (as the current mainstream development language) 5, the whim of the MySQL (and PHP collocation of the best combination) to upgrade to 4.1.11, because there is nothing on the machine ...