doujuan2688 2014-06-13 12:34
浏览 21
已采纳

MySQL和生产之间的MySQL中的不同字符串

I would need your help on this one because I can't find the solution myself:

I have a project built on cakephp ver 2.5.1. I'm entering data into my database on localhost (MAMP on my macbook; VARCHAR 255 utf8_bin - string being saved: HP) and all strings saved on my localhost appear in numbers (string HP is being saved as 4850).

The funny thing is if I copy that same database and import it on my production server all the strings are correct, HP is HP and not 4850... so I'm guessing I just misconfigured something on localhost...

Any help on the matter will be greatly appreciated!

  • 写回答

2条回答 默认 最新

  • dscpg80066 2014-06-13 13:09
    关注

    Try this: in phpmyadmin table display page, click on the '+ Options' link and uncheck "Show binary contents as HEX"

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 优质github账号直接兑换rmb，感兴趣伙伴可以私信
  • ¥15 错误(10048): “调用exui内部功能”库命令的参数“参数4”不能接受空数据。怎么解决啊
  • ¥15 安装svn网络有问题怎么办
  • ¥15 Python爬取指定微博话题下的内容，保存为txt
  • ¥15 vue2登录调用后端接口如何实现
  • ¥65 永磁型步进电机PID算法
  • ¥15 sqlite 附加（attach database）加密数据库时，返回26是什么原因呢？
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能？(关键词-串口)