Phpmyadmin - 符号 ° 错误
我的 Phpmyadmin 数据库似乎有一个奇怪的问题。当我在表 subject 中使用符号 ° 时，它会给出错误并且不会插入，对于我的表 message 但这不会有所作为。
我尝试将其作为 VARCHAR 和 TEXT，但都给出错误。消息字段是一个 TEXT 并且不会给出任何错误。
我的输出为：utf8_general_ci、latin1_swedish_ci、latin1_swedish_ci
错误：
DB Error #1366
INSERT INTO table SET created=NOW() ,ticketID=7403, subject='FW: Stackoverflow N� 456'
Incorrect string value: 'xB0 4100...' for column 'subject' at row 1
I seem to have a weird problem with my Phpmyadmin database. When I use the symbol ° in my table subject it gives an error and won't insert, for my table message however this doesn't make a difference.
I tried it as a VARCHAR and as TEXT, but both give errors. The message field is a TEXT and doesn't give any errors.
I found this: http://fogbugz.stackexchange.com/questions/2156/how-do-i-fix-incorrect-string-value-x-errors-when-running-on-mysql
My outputs are: utf8_general_ci, latin1_swedish_ci, latin1_swedish_ci
Error:
DB Error #1366
INSERT INTO table SET created=NOW() ,ticketID=7403, subject='FW: Stackoverflow N� 456'
Incorrect string value: 'xB0 4100...' for column 'subject' at row 1
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
将表的排序规则更改为 utf8_general_ci
Change Collation of your table to utf8_general_ci
我能够让它与我的程序供应商提供的补丁一起工作。
I was able to get it to work with a patch supplied by the vendor of my program.