The error is as follows:
Illegal mix of collations (gbk_chinese_ci,implicit)
and (gbk_bin,implicit) for operation ' = ',
SQL state:hy000, Error code:1267
Error Reason:
The encoding of the database is different from the coding of the table;
Copy Code code as follows:
Update dede_addonsoft SET dxylink=replace (Dxylink, '. zip ', '. rar ') where aid > 45553;
Copy Code code as follows:
Update ' table_name ' SET field = replace (field, '. rar ', '. 7z ');
There is a character set translator between the MySQL client and the MySQL server.
Character_set_client =>GBK: The converter knows that the client sent the code in GBK format.
CHARACTER_SET_CONNECTION=>GBK: Converts data transferred from client
MySQL provides a variety of character set and collation choices, where character set settings and data storage are related to the interaction of the client with the MySQL instance, and the collation and string comparison rules are related. The
There are many types of character sets in the database, and the main influence on programming is the client character set and database character set (there is also a server character set, do not know what to do).
The common operation in the
The problem is usually caused by multiple table or cross-Library table queries because the character set of the two tables is not the same, so why are the character sets of the two tables different? This is due to the fact that the architect or
Customer-side Character set: Character_set_client utf8mb4Connection Character Set: CHARACTER_SET_CONNECTIONUTF8MB4Database Character Set: CHARACTER_SET_DATABASEUTF8MB4File system Character Set: Character_set_filesystembinaryResult Character Set:
For mysql5.5 above.Windows platform:\s View the character encoding of the server, Db, Client, Conn, and the inconsistency should be changed to consistentUnified character Encoding:New My.ini in MySQL installation directory, add content, can refer to
1. List all the character sets supported by MySQL:SHOW CHARACTER SET;2. Current MySQL server character set settingsSHOW VARIABLES like ' character_set_% ';3. Current MySQL server character set checksum settingsSHOW VARIABLES like ' collation_% ';4.
The mysql5.6 Community Edition is installed.After installation, the encoding is set to UTF8In the MySQL INI file[Mysql]default-character-set=utf8[mysqld]default-character-set=utf8init_connect = ' Set NAMES UTF8 ' When building a library, an
A character set is a set of characters and encodings, which are a set of rules for comparing character sets.So the character set has two parts that make up the character set and the corresponding encoding set. For example, now there are these
1. Open a Command Prompt window, where the command prompt window itself has a character set that is viewed by right-clicking on the title bar of the command Prompt window and selecting the default value - Options - The default code page allows you
Common character sets include ASCII, GB2312, GBK, UTF-8, UnicodeThe first thing to knowASCII encoding:A byte is used to identify 0-9 digits, uppercase and lowercase letters, and some punctuation and invisible characters. 1 bytes 8 bits, can have 256
MySQL includes character set support this enables you to store data using a variety of character sets and perform Comparis ONS according to a variety of collations. You can specify character. MySQL supports the use of characterMySQL supports
1. List all the character sets supported by MySQL:SHOW CHARACTER SET;2. Current MySQL server character set settingsSHOW VARIABLES like ' character_set_% ';3. Current MySQL server character set checksum settingsSHOW VARIABLES like ' collation_% ';4.
I believe everyone knows about the DB2 character set. So where is the importance of the DB2 character set for the DB2 database? The following uses MySql and DB2 as an example to explain the character set of the database.
The default character set is
Welcome to the Linux community forum and interact with 2 million technical staff. MySQL strings are classified into two categories: 1) binary strings: a string of bytes. The interpretation of bytes does not involve character sets, therefore, it does
There are many types of character sets in the MySQL database, and the main impact on programming is the client Character Set and database character set (there is also a server character set that doesn't know what to do ).Common Operations in
1.Convert the number of a character to a number. For example, convert '0' to 0, which can be directly implemented by addition.For example, sort d in the pony table and define d as varchar.Select * from pony order by (d + 0)2. when performing ifnull
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.