By drakeguan on

I did test drupal 4.7 beta3 by creating several nodes in Chinese (encoding: UTF-8) and the display is not correct @@; does anyone know how to solve it ?

⋅ Categories: Drupal 4.7.x

Comments

kzeng’s picture

kzeng commented

hehe, what do you mean by saying the display is not correct? Could you please give more details? I have drupal 4.7 beta 3 in my test website. It works pretty well.

--------------------------
http://www.kzeng.info

drakeguan’s picture

drakeguan commented

check this image :)

http://static.flickr.com/42/87255774_91a6ac7b0f.jpg

or you can just copy & paste several Chinese setences to create a node and see how it is. actually, the preview with Chinese works well but not display.

interestingly, is your web drupal 4.7 beta3 ? it seems there is no Chinese problem in your web site.

kzeng’s picture

kzeng commented

hi, I cannot reproduce your problem. I did copy & paste some Chinese words and create a node in drupal 4.7 beta 3. Everything works pefect, as shown in my test drupa-powered website:

http://test.kzeng.info/

I tested both simplified and traditional Chinese. No problem was found. So I guess it's not a problem of Drupal 4.7. Maybe it is cuased by your database, I think.

--------------------------
http://www.kzeng.info

drakeguan’s picture

drakeguan commented

Hi Kzeng,

Thx for your replying & testing. I also tested on your web site and as you said, it works well. I am considering what happened to my mysql database. the following is the system information:

Gallery version = 2.0.2 core 1.0.0.2
PHP version = 5.0.5-2ubuntu1 apache2handler
Webserver = Apache/2.0.54 (Ubuntu) DAV/2 SVN/1.2.0 mod_python/3.1.3 Python/2.4.2 PHP/5.0.5-2ubuntu1
Database = mysqlt 4.1.12-Debian_1ubuntu3-log
Toolkits = ArchiveUpload, Exif, Ffmpeg, NetPBM, Thumbnail, Gd, ImageMagick
Operating system = Linux svn 2.6.12-9-386 #1 Mon Oct 10 13:14:36 BST 2005 i686
Browser = Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050922 Firefox/1.0.7 (Ubuntu package 1.0.7)

do you have any suggestion ?

Steven’s picture

Steven commented

This is probably caused by the MySQL database encoding being set up incorrectly. There is a patch in the works for 4.7 which should force the database encoding to UTF-8, but in the meantime you have to set it up yourself.

--
If you have a problem, please search before posting a question.

drakeguan’s picture

drakeguan commented

thx :)

I did install another drupal 4.7 beta3 and it works now. the major difference is how I create database tables in mysql. the buggy one is by phpmyadmin and the correct one is by command line.

actually, I have been playing collation for a while and still doens't get the idea. well, kinda hard problem for me right now :p

Wesley Tanaka’s picture

Wesley Tanaka commented

is here: http://drupal.org/node/40515

Treehouse