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
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
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
Remove latin1 encoded characters from MySQL, display garbled output, PHP How to convert to UTF8 format?
Reply content:
Remove latin1 encoded characters from MySQL, display garbled output, PHP How to convert to UTF8 format?
PHP itself only
Because the UTF8 character set is the character set that is best suited to implement conversions between many different character sets, although you may not be able to view the contents of the database correctly on command-line tools, I strongly
Open a Notepad under Windows and save the file with four encoding choices below. ANSI, which is the multibyte character set, is the char (char) string in VC. Unicode, which is UTF16, is the WCHAR (wchar_t) string in VC. Unicode big endian, is UTF32,
Objective:
To tell you the truth,Sandals also think UTF8 is a good thing ...After all, the same screen shows the attractiveness of Japan and Korea to East Asians is not small ...(Of course the benefits are not just this ... )Not only the Web
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.