sql collation utf8

What is the difference between utf8_general_ci and utf8_unicode_ci in  mysql? In the programming language, usually Unicode to the Chinese character to do processing, to prevent garbled, then in MySQL, why do we all use utf8_general_ci instead of utf8

Text: A summary of the knowledge about collation and character set in SQL Server and MySQLCharacter sets && sorting rulesA character set is a collection of character encodings for different languages, such as the UTF-8 character set, the GBK

The collation of SQL Server is roughly divided into Windows collation and SQL Servers collation. When the data is installed, defaults to Sql_latin1_general_cp1_ci_ai are not set by default. When the database is created, if you do not set a collation

Brief Description Character set and proofing rules A character set is a set of symbols and encodings. A proofing rule is a set of rules used to compare characters within a character set. MySQL in collation to provide strong support, oracel in this

The concept of character set is clear to everyone. Many people do not understand the proofreading rules. This concept is not used in general database development. mysql seems very advanced in convenience. The concept of character set is clear to

Brief Description Character Set and verification rulesCharacter Set is a set of symbols and encoding. A collation is a set of rules used to compare characters in a character set.MySql provides strong support in collation, and mongoel does not find

Since MySQL supports Unicode, UTF8 is also considered for our web programs to keep pace with the times. In fact, UTF8 has been used for several years, and the program can basically run, there is no big problem, but when data is swapped, it is always

Since MySQL supports Unicode, to keep pace with the times, our webProgramWe also started to consider using utf8. In fact, utf8 has been used for several years, and the program can basically run, there is no big problem, but when data is swapped, it

It is very important for MySql to change the database encoding to UTF8 when creating a database. Many developers use the default encoding, which is difficult to prevent. Coding databases can avoid garbled characters caused by import and export.

Since MySQL supports Unicode, our web programs are starting to think about using UTF8 to keep up with the times. In fact, UTF8 also used for several years, the basic program can run, no big problem, but the data switching, always encounter