MySQL Learning notes (7) 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;

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

MySQL Learning notes (7) Character set and proofing rules