Both char encoding and collation of your MySQL database need to be utf8. The default collation for utf8 encoding is uft8_general_ci, however if you created your database through phpMyadmin, it may not be the case. Please check your database to see what you have there.
I think that could be the reason. But the server only allow me use Fantastico to install Drupal. I am not sure whether it uses phpMyadmin. All I can do is to directly modify those php script files. I have no idea which file I should look into. Could you give me more clue. Thanks for the help.
Do you have means to access your database? Shell access is preferred, but I think at least you should have acess to phpMyadmin, otherwise how can you maintain your site? BTW, I used Fantastico in 4.6 and it was fine, however 4.7 might be different.
Yes. I have access to phpMyadmin, and the collation for the database is set to latin1_general_ci. I don't know know to change the collation for all the tables created.
BTW, I had created 2 databases for Wordpress with collation all set to latin1_general_ci. They all works fine for Chinese. Why?
这么复杂啊！Is there any simple way of doing this? If have to, in which format should I export the table? I tried, but the result of these exported tables were very messy. Or, shall I use shell to edit the database files? but I am not sure which files I should modify.
Drupal China
这个以前有人讨论过
这个以前有人讨论过在这里:http://www.drupalchina.org/node/288
-------------------
欢迎访问我的blog: http://www.kzeng.info/
如果不能访问，feed地址： http://feeds.feedburner.com/kzeng_stupid_words
-------------------
欢迎访问我的blog: http://www.kzeng.info/
如果不能访问，feed地址： http://feeds.feedburner.com/kzeng_stupid_words
无法创建中文内容
谢谢!
我查了一下,发现database的default setting 就是utf-8.还是不明白问题出在哪里.
How about collation?
What about collation?
无法创建中文内容
Can you explain what collation is ?
Both char encoding and
Both char encoding and collation of your MySQL database need to be utf8. The default collation for utf8 encoding is uft8_general_ci, however if you created your database through phpMyadmin, it may not be the case. Please check your database to see what you have there.
Both char encoding and
I think that could be the reason. But the server only allow me use Fantastico to install Drupal. I am not sure whether it uses phpMyadmin. All I can do is to directly modify those php script files. I have no idea which file I should look into. Could you give me more clue. Thanks for the help.
Do you have means to access
Do you have means to access your database? Shell access is preferred, but I think at least you should have acess to phpMyadmin, otherwise how can you maintain your site? BTW, I used Fantastico in 4.6 and it was fine, however 4.7 might be different.
Do you have means to access
Yes. I have access to phpMyadmin, and the collation for the database is set to latin1_general_ci. I don't know know to change the collation for all the tables created.
BTW, I had created 2 databases for Wordpress with collation all set to latin1_general_ci. They all works fine for Chinese. Why?
可以在phpMyadmin里先导
可以在phpMyadmin里先导出所有table并备份。
打开导出的sql文件，把所有的
CHARSET=latin类似的字样都换成 utf8Drop现有的table，重新导入修改过的sql
Drupal4.6原来没有这个问题，但从4.7开始限定database encoding/connection都是utf8，所以必须要做以上修改。Wordpress估计和drupal4.6类似，没有硬性规定database encoding，所以没有这个问题。
可以在phpMyadmin里先导
这么复杂啊！Is there any simple way of doing this? If have to, in which format should I export the table? I tried, but the result of these exported tables were very messy. Or, shall I use shell to edit the database files? but I am not sure which files I should modify.
How about collation? Do I have to change too?
在shell里直接导入是最
在shell里直接导入是最简单的了；不过好像你没有shell acess，上面的phpMyadmin的办法也不麻烦，试一下，挺简单的。