I converted my mysql 5.7 database to utf8mb4 today.
As a test, I've put a poo emoji (
使用utf8mb4的PHP / mysql站点不能正确地从数据库中检索表情符号，尽管在任何地方都指定了utf8mb4，我可以找到它来放置它
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
分享- 邀请回答
-
1条回答 默认 最新
- dongzanghong4379 2016-10-12 08:19关注
The problem was an outdated version of Navicat. Upgrading from 8 to 11 has fixed my issues. I realised this was probably the cause when I discovered that emojis INSERTed via php were correctly stored and retrieved in PHP, but wouldn't show correctly in Navicat.
Similarly the opposite was true; emojis set in Navicat would correctly store and retrieve in Navicat, but not in PHP.
Looking at the encoding options for navicat connections, it had a checkbox for "use mysql encoding", but if left unchecked the dropdown of possible options included only utf8, not utf8mb4. I guess navicat 8 pre-dates that being in common usage.
A quick upgrade, and everything works perfectly.
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏举报 分享
- 回答 1 已采纳 The problem was an outdated version of Navicat. Upgrading from 8 to 11 has fixed my issues. I re
- 2018-11-13 06:52回答 4 已采纳 instead of $sSQL= 'SET CHARACTER SET utf8'; mysqli_query($conn,$sSQL); try mysqli_set_chars
- 2016-10-15 14:57回答 1 已采纳 I have a solution here. Finally it worked with my persistent attack. Thanks all for your help and
- 2021-02-01 19:23白鹡鸰的博客 utf8 与 utf8mb4标准的 ...然而在MySQL里实现的utf8最长使用3个字节，节省空间但不能表达全部的UTF-8，只支持到了 Unicode 中的“基本多文种平面”(U+0000至U+FFFF，Basic Multilingual Plane，BMP)，包含了控制符...
- 2013-04-26 19:24回答 2 已采纳 echo "<ul> <li> ".$firstname. " ".$lastname ." </
- 2015-07-16 23:54回答 1 已采纳 For your form, I suggest the following: <?php session_start(); ?> <!doctype html> <
- 2016-05-12 19:04回答 1 已采纳 You can do it like as follows: Replace the following line of your code with my code: if($rs['adv
- mingjie1212的博客 CREATE DATABASE `springcloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ; 字符集 排序规则 utf8 … utf8_general_ci utf8_unicode_ci utf8mb4 … utf8mb4_.
- 2015-12-03 07:43回答 2 已采纳 You need to compare the id with inserted id in the function. You can try this - function article
- 2015-10-07 15:07回答 2 已采纳 I was able to get the result I wanted using html_entity_decode. Thank you
- 2016-07-11 06:19回答 1 已采纳 Your php query is wrong Initialize array first Note that $result is not your array $menus= array(
- 2021-03-13 03:13沈一冰的博客 详解JDBC对Mysql utf8mb4字符集的处理写在前面在开发微信小程序的时候,评论服务模块希望添加上emoji表情,但是emoji表情是4个字节长度的,所以需要进行设置当前项目是JAVA编写, 使用JDBC连接操作数据库, 如下针对的...
- 2015-04-10 13:26回答 3 已采纳 Just a few changes to your code. I think the biggest problem was that you're not looping over your
- 2021-01-21 23:25初学者leon的博客 问题： 在 mysql 数据库中导入sql文件时，出现的 error 信息， Unknown collation: 'utf8mb4_0900_ai_ci' 分析： ...在MySQL5.6，MySQL5.7中选择字符集为utf8mb4时，默认的排序规则是utf8m...
- 2018-07-24 20:03砖业洋__的博客 全网最详细MySQL教程，2023持续更新中
- 没有解决我的问题, 去提问
悬赏问题
- ¥20 求数据集和代码#有偿答复
- ¥15 关于下拉菜单选项关联的问题
- ¥20 java-OJ-健康体检
- ¥15 rs485的上拉下拉，不会对a-b<-200mv有影响吗，就是接受时，对判断逻辑0有影响吗
- ¥15 使用phpstudy在云服务器上搭建个人网站
- ¥15 应该如何判断含间隙的曲柄摇杆机构，轴与轴承是否发生了碰撞？
- ¥15 vue3+express部署到nginx
- ¥20 搭建pt1000三线制高精度测温电路
- ¥15 使用Jdk8自带的算法，和Jdk11自带的加密结果会一样吗，不一样的话有什么解决方案，Jdk不能升级的情况
- ¥15 画两个图 python或R