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
Introduction: This is a detailed page of MySQL database encoding problem 3 (modifying the database, table, and field encoding to utf8). It introduces the related knowledge, skills, and experience of PHP, and some PHP source code.
Class = 'pingjiaf'
in C + + programming, we often deal with nothing more than the editor and compiler, to the editor said, we often encounter is garbled problem, such as Chinese note display or can not save, the solution is to save your file as Unicode (UTF8). for the
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
It is important for MySql to modify the database encoding to UTF8 to avoid gibberish. bitsCN. commysql to specify the encoding when creating the database. many developers use the default encoding, which is difficult to prevent. Coding databases can
There is nothing else to say, just look at it.
Code You can, the only one that needs to be noted is that the three commonly used character encodings in C ++ are MBCS, Unicode, and utf8. New users are generally confused about this issue.
MBCS is a
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% '; +-
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.
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
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
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.