sql set 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'

One, login MySQL view with show variables like ' character% '; The following character set, which is displayed as follows: +--------------------------+----------------------------+ | variable_name | Value | +--------------------------+--------

" This article declined to reprint Original from http://990487026.blog.51cto.com"Thought:1, set the Linux character set to UTF8 encoding2, set the Oracle character set to UTF8 encoding3, set the Sqlplus client environment to UTF8 encoding4. If you

several character sets involved in MySQL Character-set-server/default-character-set: Server character set, by default. Character-set-database: Database character set. Character-set-table: Database table character Set. Priority increases in order.

MySQL character set meaning see MySQL manual section 10.1 character Set support MySQL Character set conversion process please look at the Bird Brother blog This article 0. Initial stateDebian uses apt to install MySQL at the beginning of this You

MySQL Chinese garbled solution: the MySQL database encoding unified UTF8To view the database encoding: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.

Since MySQL supports Unicode, our web programs are starting to think about using UTF8 to keep up with the times. In fact, UTF8 also used for several years, the basic program can run, no big problem, but the data switching, always encounter

Since MySQL supports Unicode, UTF8 is also considered for our web programs to keep pace with the times. In fact, UTF8 has been used for several years, and the program can basically run, there is no big problem, but when data is swapped, it is always

Since MySQL supports Unicode, to keep pace with the times, our webProgramWe also started to consider using utf8. In fact, utf8 has been used for several years, and the program can basically run, there is no big problem, but when data is swapped, it