MySQL Learning notes (5) Character set and proofing rules

Character set and proofing rules

1. Character set: A set of symbols and character encodings.

2. Proofing Rules: A set of rules that are used to compare characters within a character set.

3, the installation of the database is best with our fixed code.

4. You can specify a character set when you create a table: ..... Charset=[gdk/utf8] ;

5. View the coded variables:show varchar like '%char%';

–character_set_server : The default internal operation character Set

–character_set_client : The character set used by the client source data

–character_set_connection: Connection layer Character Set
–character_set_results: Query result character Set
–character_set_database: The default character set for the currently selected database
–character_set_system: System metadata ( field name, etc. ) Character Set
– there are also variables that begin with Collation_ to describe the character Fu She.

6. To change the encoding variable: Set Names coding;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/75/A2/wKiom1Y_NdPQBazsAABxmKHNHiQ574.png "style=" float: none; "title=" Image 1.png "alt=" Wkiom1y_ndpqbazsaabxmkhnhiq574.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/75/A2/wKiom1Y_NdPwQgMqAABHCkvNVcY420.png "style=" float: none; "title=" Image 2.png "alt=" Wkiom1y_ndpwqgmqaabhckvnvcy420.png "/>

This article is from the "Learning and Exchange" blog, please be sure to keep this source http://chenhaolinux.blog.51cto.com/9609922/1710771

MySQL Learning notes (5) Character set and proofing rules