官术网_书友最值得收藏!

Character sets and collations

A character set describes how symbols for a specific language or dialect are encoded. A collation contains rules to compare and sort the characters of a character set. The character set used to store our data may be different from the one used to display it, leading to data discrepancies. Thus, a need to transform the data arises.

Since MySQL 4.1.x, the MySQL server does the character recoding work for us. Also, MySQL enables us to indicate the character set and collation for each database, each table, and even each field. A default character set for a database applies to each of its tables, unless it is overridden at the table level. The same principle applies to every column.

Effective character sets and collations

On the home page, we can see the MySQL charset information and a MySQL connection collation selector. Here is the MySQL charset information:

Effective character sets and collations

The character set information (as seen here after MySQL charset) is used to generate HTML information, which tells the browser what is the page's character set.

We can also choose which character set and collation will be used for our connection to the MySQL server using the MySQL connection collation dialog. This is passed to the MySQL server. MySQL then transforms the characters that will be sent to our browser into this character set. MySQL also interprets what it receives from the browser according to the character set information. Remember that all tables and columns have a character set information describing how their data is encoded.

Effective character sets and collations

Normally, the default value should work. However, if we are entering some characters using a different character set, we can choose the proper character set in this dialog.

The following parameter defines both the default connection collation and character set:

$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
主站蜘蛛池模板: 宜宾市| 湛江市| 铜鼓县| 嘉祥县| 沭阳县| 景谷| 鲁甸县| 思茅市| 乐安县| 汕尾市| 准格尔旗| 望城县| 凤翔县| 汕尾市| 岗巴县| 财经| 孝感市| 通化市| 奇台县| 高阳县| 盐山县| 宜宾县| 漳州市| 额尔古纳市| 康平县| 宿州市| 武鸣县| 三原县| 隆尧县| 沅江市| 稻城县| 昆明市| 南汇区| 仙居县| 新乐市| 宜兰县| 吉林省| 佛教| 新津县| 墨江| 盐亭县|