The following is a very boring thing, full of a lot of various coding, conversion, client, server side, connection ... Well, I don't want to see it myself, but I think it's a little bit of a point to write down, for four reasons:
MySQL 4.1 's support for multiple languages has changed a lot (which leads to problems);
Although most of the places (including personal use and hosting providers), MySQL 3 is still dominant, but MySQL 4.1 is the official MySQL recommended database, already have the host provider started to provide and will be more and more;
Many PHP programs use MySQL as the default database management software, but they generally do not distinguish between MySQL 4.1 and 4.1 versions of the difference, generally referred to as "MySQL 3.xx.xx above version" to meet the installation requirements;
Because latin1 in many places (below will describe in detail where specifically where) as the default character set, the success of the many PHP programs to deceive the developers and users, to cover up in the Chinese language environment will appear in the problem;
To put it simply, MySQL's own changes and the use of MySQL's PHP program to ignore this, causing problems and complications, and because most users use English, so that the problem is not taken seriously. The PHP program mentioned here, mainly in terms of WordPress.
Principles supported by the MySQL 4.1 character set
MySQL 4.1 Specifies that the character set can be refined to a machine installed on MySQL, where a database, one of the tables, one of the columns, should use what character set. However, traditional WEB programs do not use a complex configuration when creating databases and datasheets, and they use the default configuration, so where does the default configuration come from?
When compiling MySQL, a default character set is specified, and the character set is latin1;
When you install MySQL, you can specify a default character set in the configuration file (My.ini), and if not specified, the value inherits from the compile-time specified;
at this time
http://www.bkjia.com/phpjc/631020.html www.bkjia.com true http://www.bkjia.com/PHPjc/631020.html techarticle The following is a very boring thing, full of a lot of different encoding, conversion, client, server side, connection uh, I don't want to see it, but think, ...
-
