blocks|key|2930371|text|4字节Unicode字符还没有被广泛使用，所以并不是所有的应用程序都完全支持它们。如果配置正确，MySQL+5.5可以很好地处理4个字节的字符--检查其他组件是否也可以使用它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2930372|以下是其他一些需要检查的内容：|2930373|2930374|除了设置客户端和服务器字符集之外，还要确保将所有表的默认字符集和文本字段转换为utf8mb4，例如ALTER+TABLE+mytable+charset=utf8mb4,+MODIFY+COLUMN+textfield1+VARCHAR(255)+CHARACTER+SET+utf8mb4,MODIFY+COLUMN+textfield2+VARCHAR(255)+CHARACTER+SET+utf8mb4;等。|unordered-list-item|offset|length|style|CODE|2930375|2930376|如果您的数据已经在utf8字符集内，它应该可以在适当的位置转换为utf8mb4，不会出现任何问题。像往常一样，在尝试之前备份你的数据！|2930377|还确保你的应用层将其数据库连接的字符集设置为utf8mb4。仔细检查一下，如果你运行的是你选择的框架的mysql客户端库的旧版本，它可能没有被utf8mb4支持编译，也不会正确设置字符集。如果没有，您可能需要对其进行更新或自行编译。|2930378|
|2930379|通过mysql客户端查看数据时，请确保您所在的计算机可以显示表情符号，并在运行任何查询之前运行SET+NAMES+utf8mb4。|2930380|2930381|一旦您的应用程序的每个级别都可以支持新字符，您应该能够在不损坏的情况下使用它们。|2930382|entityMap^0|0|0|0|1D|4D|0|0|0|0|0|1B|H|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|12|8|@$H|13|I|14|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|16|8|@]|9|@]|A|$]]|$1|O|3|P|5|G|7|17|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|18|8|@]|9|@]|A|$]]|$1|S|3|T|5|G|7|19|8|@$H|1A|I|1B|J|K]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1D|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|Y|$]]

4 byte Unicode characters aren't yet widely used, so not every application out there fully supports them. MySQL 5.5 works fine with 4 byte characters when properly configured – check if your other components can work with them as well.

Here's a few other things to check out:

<ul>
<li>Make sure all your tables' default character sets and text fields are converted to utf8mb4, in addition to setting the client &amp; server character sets, e.g.
<code>ALTER TABLE mytable charset=utf8mb4, MODIFY COLUMN textfield1 VARCHAR(255) CHARACTER SET utf8mb4,MODIFY COLUMN textfield2 VARCHAR(255) CHARACTER SET utf8mb4;</code> and so on.

If your data is already in the utf8 character set, it should convert to utf8mb4 in place without any problems. As always, back up your data before trying!</li>
<li>Also make sure your app layer sets its database connections' character set to utf8mb4. Double-check this is actually happening – if you're running an older version of your chosen framework's mysql client library, it may not have been compiled with utf8mb4 support and it won't set the charset properly. If not, you may have to update it or compile it yourself.</li>
<li>When viewing your data through the mysql client, make sure you're on a machine that can display emoji, and run a <code>SET NAMES utf8mb4</code> before running any queries.</li>
</ul>

Once every level of your application can support the new characters, you should be able to use them without any corruption.

blocks|key|250342|text|我最近写了+。如果你遵循这里的步骤，一切都应该正常工作。以下是该过程中每个步骤的直接链接：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|250343|250344|Step+1:+Create+a+backup|unordered-list-item|250345|Step+2:+Upgrade+the+MySQL+server|250346|Step+3:+Modify+databases,+tables,+and+columns|250347|Step+4:+Check+the+maximum+length+of+columns+and+index+keys|250348|Step+5:+Modify+connection,+client,+and+server+character+sets|250349|Step+6:+Repair+and+optimize+all+tables|250350|250351|希望这能有所帮助。|250352|entityMap|0|LINK|mutability|MUTABLE|url|https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4|1|https://mathiasbynens.be/notes/mysql-utf8mb4#backup|2|https://mathiasbynens.be/notes/mysql-utf8mb4#upgrade|3|https://mathiasbynens.be/notes/mysql-utf8mb4#databases-tables-columns|4|https://mathiasbynens.be/notes/mysql-utf8mb4#column-index-length|5|https://mathiasbynens.be/notes/mysql-utf8mb4#character-sets|6|https://mathiasbynens.be/notes/mysql-utf8mb4#repair-optimize^0|5|1|0|0|0|0|N|1|0|0|W|2|0|0|19|3|0|0|1M|4|0|0|1O|5|0|0|12|6|0|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@$A|1F|B|1G|1|1H]]|C|$]]|$1|D|3|-4|5|6|7|1I|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|1J|8|@]|9|@$A|1K|B|1L|1|1M]]|C|$]]|$1|H|3|I|5|G|7|1N|8|@]|9|@$A|1O|B|1P|1|1Q]]|C|$]]|$1|J|3|K|5|G|7|1R|8|@]|9|@$A|1S|B|1T|1|1U]]|C|$]]|$1|L|3|M|5|G|7|1V|8|@]|9|@$A|1W|B|1X|1|1Y]]|C|$]]|$1|N|3|O|5|G|7|1Z|8|@]|9|@$A|20|B|21|1|22]]|C|$]]|$1|P|3|Q|5|G|7|23|8|@]|9|@$A|24|B|25|1|26]]|C|$]]|$1|R|3|-4|5|6|7|27|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|28|8|@]|9|@]|C|$]]|$1|U|3|-4|5|6|7|29|8|@]|9|@]|C|$]]]|V|$W|$5|X|Y|Z|C|$10|11]]|12|$5|X|Y|Z|C|$10|13]]|14|$5|X|Y|Z|C|$10|15]]|16|$5|X|Y|Z|C|$10|17]]|18|$5|X|Y|Z|C|$10|19]]|1A|$5|X|Y|Z|C|$10|1B]]|1C|$5|X|Y|Z|C|$10|1D]]]]

I’ve recently written <a href="https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4">a detailed guide on how to switch from MySQL’s <code>utf8</code> to <code>utf8mb4</code></a>. If you follow the steps there, everything should work correctly. Here are direct links to each individual step in the process:

<ul>
<li><a href="https://mathiasbynens.be/notes/mysql-utf8mb4#backup">Step 1: Create a backup</a></li>
<li><a href="https://mathiasbynens.be/notes/mysql-utf8mb4#upgrade">Step 2: Upgrade the MySQL server</a></li>
<li><a href="https://mathiasbynens.be/notes/mysql-utf8mb4#databases-tables-columns">Step 3: Modify databases, tables, and columns</a></li>
<li><a href="https://mathiasbynens.be/notes/mysql-utf8mb4#column-index-length">Step 4: Check the maximum length of columns and index keys</a></li>
<li><a href="https://mathiasbynens.be/notes/mysql-utf8mb4#character-sets">Step 5: Modify connection, client, and server character sets</a></li>
<li><a href="https://mathiasbynens.be/notes/mysql-utf8mb4#repair-optimize">Step 6: Repair and optimize all tables</a></li>
</ul>

Hope this helps.

How to insert utf-8 mb4 character(emoji in ios5) in mysql?

我使用的是mysql 5.5.10，它的character_sets是| character_set_client     | utf8mb4                    || character_set_connection | utf8mb4                    || character...

问如何在mysql中插入utf-8表情字符(ios5中的mb4 )？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在mysql中插入utf-8表情字符(ios5中的mb4 )？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在mysql中插入utf-8表情字符(ios5中的mb4 )？
EN