存储波兰语字符mysql [英] store polish characters mysql

问题描述

我正在尝试保存±"，ć"，ł"等字符，但它们以问号形式保存在数据库中(我使用phpMyAdmin保存了它们).

I am trying to save characters like "ą", "ć", "ł" but they are saved in the database as question marks (I save them using phpMyAdmin).

数据库和表的排序规则是utf8_bin.

The database and table's collation is utf8_bin.

推荐答案

尝试将排序规则更改为:

Try changing the collation to:

utf8_unicode_ci 

或

utf8_polish_ci 

您可以参考: http://mysql.rjweb.org/doc.php/charcoll

您还可以尝试通过以下方式更改特定列:

Also you can TRY altering the specific column with:

ALTER TABLE tbl MODIFY COLUMN txt TEXT CHARACTER SET utf8

这篇关于存储波兰语字符mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！