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; "Width=" 617 "height=" 209 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>

650) this.width=650 "width=" 605 "height=" "src="/e/u261/themes/default/images/spacer.gif style= "Background:url" ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>

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

The character set and proofing rules for the

MySQL Learning Note (5)