mysql convert 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 problem is this: A test table, the character set used by the latin1. Select to_id from test where to_id= ' cn like _ King '; +---------------+ | to_id | +---------------+ | CN Ceramics _ Pottery | | cn like _ King | +---------------+ 2 rows in

Original: MySQL physical file Architecture Simple collation descriptionThe source of this article: http://www.cnblogs.com/wy123/p/7102128.html(It is not the original works right to retain the source, I my book still far to reach, just to link to the

Character Set issues:Basic concepts? A character (Character) is the smallest of the ideographic symbols in a human language. such as ' A ', ' B ' and so on;? Given a series of characters, each character is given a numeric value that represents the

The problem is this: A test table, the character set used by the latin1. Select to_id from test where to_id= ' cn like _ King '; +---------------+ | to_id | +---------------+ | CN Ceramics _ Pottery | | cn like _ King | +---------------+ 2 rows in

The source of this article: http://www.cnblogs.com/wy123/p/7102128.html(It is not the original works right to retain the source, I my book still far to reach, just to link to the original text, because the following may exist some errors to amend or

It took so long to find out that I didn't know what the difference was between Utf_bin and Utf_general_ci.CI is case insensitive, that is, "case-insensitive", A and a will be treated as the same in character judgments;The bin is binary, and a and a

1 Character Set issuesProblem: Executing the./manage.py createdb command in Django appears:Django.db.utils.OperationalError: (1366, "Incorrect string value: ' \\xC4\\x9A\\xC2\\x81vi ... ' for column ' file ' at row 1" )To view the MySQL

We can use show variables like character to view character encoding in mysql. modify the configuration method in my. ini. Let's take a look at it. Recently, in the mysql database used by the project team, garbled data is inserted. We have summarized

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