blocks|key|1501887|text|要使其“永久”，请在my.cnf中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1501888|[client]
default-character-set=utf8
[mysqld]
character-set-server+=+utf8|code-block|syntax|javascript|1501889|要进行检查，请转到客户端并显示一些变量：|1501890|SHOW+VARIABLES+LIKE+'character_set%25';|1501891|验证它们是否都是utf8，..._filesystem除外，它应该是binary和..._dir，它指向MySQL安装中的某个位置。|1501892|entityMap^0|A|6|0|0|0|0|8|4|D|E|Y|6|15|7|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]|$9|15|A|16|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|R|$]]

To make this 'permanent', in <code>my.cnf</code>:

<pre><code>[client]
default-character-set=utf8
[mysqld]
character-set-server = utf8
</code></pre>

To check, go to the client and show some variables:

<pre><code>SHOW VARIABLES LIKE 'character_set%';
</code></pre>

Verify that they're all <code>utf8</code>, except <code>..._filesystem</code>, which should be <code>binary</code> and <code>..._dir</code>, that points somewhere in the MySQL installation.

blocks|key|1717124|text|UTF4.1及更高版本有一个名为utf8的默认字符集，但它实际上只是MySQL+-8的子集(只允许三个字节或更小的字符)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1717125|如果您想要“完整”的UTF-8，请使用utf8mb4作为您的字符集。|1717126|entityMap^0|G|4|0|J|7|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

MySQL 4.1 and above has a default character set that it calls <code>utf8</code> but which is actually only a subset of UTF-8 (allows only three-byte characters and smaller).

Use <code>utf8mb4</code> as your charset if you want "full" UTF-8.

blocks|key|1717024|text|字符集是数据库(默认)和表的属性。您可以查看一下(MySQL命令)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1717025|show+create+database+foo;+
>+CREATE+DATABASE++`foo`.`foo`+/*!40100+DEFAULT+CHARACTER+SET+latin1+*/

show+create+table+foo.bar;
>+lots+of+stuff+ending+with
>+)+ENGINE=InnoDB+AUTO_INCREMENT=252+DEFAULT+CHARSET=latin1|code-block|syntax|javascript|1717026|换句话说，检查或更改数据库字符集非常容易：|1717027|ALTER+TABLE+`foo`.`bar`+CHARACTER+SET+utf8;|1717028|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The charset is a property of the database (default) and the table.
You can have a look (MySQL commands):

<pre><code>show create database foo; 
&gt; CREATE DATABASE `foo`.`foo` /*!40100 DEFAULT CHARACTER SET latin1 */

show create table foo.bar;
&gt; lots of stuff ending with
&gt; ) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=latin1
</code></pre>

In other words; it's quite easy to check your database charset or change it:

<pre><code>ALTER TABLE `foo`.`bar` CHARACTER SET utf8;
</code></pre>

blocks|key|1502130|text|要将数据库本身的字符集编码更改为UTF-8，请在mysql>提示符下键入以下命令。使用ALTER+DATABASE..将DBNAME替换为数据库名称：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1502131|ALTER+DATABASE+DBNAME+CHARACTER+SET+utf8+COLLATE+utf8_general_ci;|code-block|syntax|javascript|1502132|这是此问题How+to+convert+an+entire+MySQL+database+characterset+and+collation+to+UTF-8?的副本|1502133|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8/34986915#34986915^0|17|E|0|0|5|24|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

To change the character set encoding to UTF-8 for the database itself, type the following command at the mysql> prompt. USE <code>ALTER DATABASE</code>.. Replace DBNAME with the database name:

<pre><code>ALTER DATABASE DBNAME CHARACTER SET utf8 COLLATE utf8_general_ci;
</code></pre>

This is a duplicate of this question <a href="https://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8/34986915#34986915">How to convert an entire MySQL database characterset and collation to UTF-8?</a>

blocks|key|1502285|text|将database+collation设置为UTF-8，然后将table+collation应用于数据库默认值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1502286|entityMap^0|1|I|M|5|V|F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

Set your <code>database collation</code> to <code>UTF-8</code>
then apply <code>table collation</code> to database default.

blocks|key|1717463|text|这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1717464|mysqli_query($connection，“设置名称'utf8'")；|1717465|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This worked for me:
mysqli_query($connection, &quot;SET NAMES 'utf8'&quot;);

blocks|key|1717444|text|到UTF-8的数据库连接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1717445|$connect+=+mysql_connect('$localhost','$username','$password')+or+die(mysql_error());
mysql_set_charset('utf8',$connect);
mysql_select_db('$database_name','$connect')+or+die(mysql_error());|code-block|syntax|javascript|1717446|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

DATABASE CONNECTION TO UTF-8

<pre><code>$connect = mysql_connect('$localhost','$username','$password') or die(mysql_error());
mysql_set_charset('utf8',$connect);
mysql_select_db('$database_name','$connect') or die(mysql_error());
</code></pre>

blocks|key|1501854|text|SET+NAMES+UTF8|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1501855|这是最好的办法|1501856|entityMap^0|0|E|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

<code>SET NAMES UTF8</code>

This is does the trick

blocks|key|1717060|text|设置到UTF8的数据库连接：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1717061|++if($handle+=+@mysql_connect(DB_HOST,+DB_USER,+DB_PASS)){++++++++++
+++++++++//set+to+utf8+encoding
+++++++++mysql_set_charset('utf8',$handle);
++}|code-block|syntax|javascript|1717062|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Set your database connection to UTF8:

<pre><code> if($handle = @mysql_connect(DB_HOST, DB_USER, DB_PASS)){ 
 //set to utf8 encoding
 mysql_set_charset('utf8',$handle);
 }
</code></pre>

blocks|key|1717158|text|找到了一个解决方案。按照http://technoguider.com/2015/05/utf8-set-up-in-mysql/中指定的方式运行以下命令|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1717159|SET+NAMES+UTF8;
set+collation_server+=+utf8_general_ci;
set+default-character-set+=+utf8;
set+init_connect+=+’SET+NAMES+utf8′;
set+character_set_server+=+utf8;
set+character_set_client+=+utf8;|code-block|syntax|javascript|1717160|entityMap|0|LINK|mutability|MUTABLE|url|http://technoguider.com/2015/05/utf8-set-up-in-mysql/^0|C|1H|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Was able to find a solution. Ran the following as specified at <a href="http://technoguider.com/2015/05/utf8-set-up-in-mysql/" rel="nofollow">http://technoguider.com/2015/05/utf8-set-up-in-mysql/</a>

<pre><code>SET NAMES UTF8;
set collation_server = utf8_general_ci;
set default-character-set = utf8;
set init_connect = ’SET NAMES utf8′;
set character_set_server = utf8;
set character_set_client = utf8;
</code></pre>

One of the responses to <a href="https://stackoverflow.com/questions/198721/converting-a-word-document-into-usable-html-in-php">a question I asked yesterday</a> suggested that I should make sure my database can handle UTF-8 characters correctly. How I can do this with MySQL?

How to make MySQL handle UTF-8 properly

数据库

MySQL

其中一个对的回复建议我应该确保我的数据库可以正确处理UTF-8字符。我怎样才能用MySQL做到这一点？

问如何使MySQL正确处理UTF8
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使MySQL正确处理UTF8EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使MySQL正确处理UTF8
EN