gpt4 book ai didi

mysql - 维基百科转储文件

转载 作者:行者123 更新时间:2023-11-29 13:32:26 26 4
gpt4 key购买 nike

我将波斯语维基百科 2007 的转储文件导入到本地 mysql 5.6。非拉丁脚本中的用户名似乎未正确保存。有什么办法解决吗?

 select DISTINCT rev_user_text from revision where rev_user_text  like '%?%';

+-------------------------------+
| rev_user_text |
+-------------------------------+
| 1?1? |
| ? |
| ? ? |
| ? ? ? |
| ? ???? |
| ?. ????????? |
| ?.???? |
| ?.??????? |
| ?.???????? |
| ?? |
| ?? ?? |
| ?? ?? ?? |
| ?? ??? |
| ?? ??? ??? |
| ??? |
| ??? 110 |
| ??? ? |
| ??? ??? |
| ??? ??? ( ?? ??? ) |
| ??? ??? ????? ??? |
| ??? ???? |
| ??? ???? ??? |
| ??? ???? ????? |
| ??? ???? ??????? |
| ??? ????? |
| ??? ????? ??? |
| ??? ????? ???? |
| ??? ????? ?????? |
| ??? ?????1984 |
| ??? ?????? |
| ??? ??????? |
| ??? ??????? ??? |
| ??? ???????? |
| ??? ?????????? |
| ???76 |
| ???? |
| ???? 32 |
| ???? ? |
| ???? ?? |
| ???? ?? ? ????? |
| ???? ??? |
| ???? ??? ? ????? ???? |
| ???? ??? ???? |
| ???? ??? ????? |
| ???? ??? ????? ????? |
| ???? ???? |
| ???? ???? ??? |
| ???? ???? ??? (??????) |
| ???? ???? ???? |
| ????.??? |
| ????22 |
| ????4183 |
| ????777 |
| ????808 |
| ????? |
| ????? - ???? ??? |
| ????? 85 8 |
| ????? ? |
| ????? ??? |
| ????? ??? ??? |
| ????? ??? ???? |
| ????? ???? |
| ????? ???? (????? ????) |
| ????? ???? --????? ???? |
| ????? ???? -????? ???? |
| ????? ???? ??? |
| ????? ???? ???? |
| ????? ???? ?????? |
| ????? ????? |
| ????? ????? ???? |
| ????? ????? ????? |
| ????? ????? ???????? |
| ????? ?????? |
| ????? ?????? ??? |
…….

最佳答案

可能您没有使用合适的字符集,例如 utf8。尝试使用以下命令重新创建表:

CREATE TABLE revisions
(...)
CHARACTER SET 'utf8';

或更改现有表的字符集:

ALTER TABLE revisions
CHARACTER SET 'utf8';

关于mysql - 维基百科转储文件,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/19225644/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com