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'
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
Background: The dnname of a MySQL database in a system adopts the default Latin1 character set. During system upgrade, all data must be converted to UTF-8 format and the target database is newdbname (utf8 is used for database creation)
Method
Programming | Chinese
"Abstract" in this article, the sandals as far as possible to introduce the UTF8 code of PHP programming, as to why the introduction of a separate "Chinese", one is because the English this thing really do not need to consider
Personally, we recommend that you use utf8 as much as possible for the database character set (the HTML page corresponds to UTF-8) so that your data can be migrated smoothly.
Personally, we recommend that you use utf8 as much as possible for the
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)
Convert MYSQL databases that contain UTF8 and latin1 encoding. if someone asks me today, I just turn it around. it's very simple. here I will explain it.
Using phpmyadmin to import data to test, we found that the database contains UTF8 and latin1
Because the utf8 character set is currently the most suitable character set for conversion between different character sets, although you may not be able to correctly view the content in the database on the command line tool, I still strongly
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.