Original: http://my.oschina.net/leejun2005/blog/343353Catalogue [-]
1. Problem: MySQL encountered some Chinese insert exception
2, Reason: This UTF8 non-UTF8
3. Solutions
3.1 Upgrading the MySQL version and upgrading the UTF8
1. Problem: MySQL encountered some Chinese Insert Exception recently, some students have feedback on such a problem: The above statement will hang when the load is in the script, the Web front end, the command line operation is either thrown
Unicode is a coding standard developed by unicode.org and is currently supported by most operating systems and programming languages. unicode.org official definition of Unicode is: Unicode provides a unique number for every character. As you can see,
1. Review of three types of codes
ANSI string we are most familiar with, English occupies one byte, Chinese characters 2 bytes, ending with a \ 0, commonly used in TXT text files.Unicode string. Each character (Chinese character or English letter)
The MySQL database is an open-source database that is widely used. The following is a procedure for modifying the character encoding of a MySQL database. Step 1: View the current character encoding method mysql> show variables like ' character% '; +-
The calculation of field lengths for Oracle and MySQL has recently been found to be different (all UTF8 encoded), such as:Defined under Oracle: Name VARCHAR2, the Name field can hold: 10 characters or 3 kanjiDefined under MySQL: Name varchar, name
Http://www.infoq.com/cn/articles/in-mysql-never-use-utf8-use-utf8I recently encountered a bug where I tried to save a UTF-8 string in a "UTF8" encoded mariadb with rails, and then a bizarre error occurred:Incorrect string value: ‘\xF0\x9F\x98\x83 I
In mysql5.1, the following Chinese Character in utf8 encoding occupies a char. mysql5.1utf8Recently, it was found that the length of the Oracle and MySQL fields is calculated differently (both are UTF-8 encoded), for example:Defined in Oracle: name
Modify database MySQL character encoding to UTF8The MySQL database is an open-source database that is widely used. The following is a procedure for modifying the character encoding of a MySQL database. Step 1: View the current character encoding
JSP uses UTF-8 link MYSQL database (UTF8) garbled and connection failure issues:
Preface: the databases used by these big companies are not human-friendly... It took me a long time to get it done.
Csdn does not seem to be able to transmit images
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.