Bug

Asian language input is displayed as ???? / #6562

Summary

open
Jun 3, 2008
Jun 3, 2008 / guest
Jun 16, 2008 / pixtur
 

Attached files

No files uploaded
As searching in the site, there were several posts on this topic, but seemed not resolved yet. For multi-byte asian language, the input and display seemed not okay.

I tried with the StreberPM latest version 0.803 in Firefox (ver: 2.0.0.14), and input chinese text in the title and wiki edit box, after submitting, it displayed "?????", while the "character encoding" in Firefox was 'utf-8' and the 'DB_USE_UTF8_ENCODING' option in customize.inc.php was 'true'.

Besides, the php in use is v5.2.4, mysql is 5.0.45.

Any help would be sincerely appreciated.

/Gerxiu

Solution

when you create the database, you should uses the mysql command
CREATE DATABASE IF NOT EXISTS streber default charset utf8 COLLATE utf8_general_ci;




Also see:

Issue report

Minor
Have not tried
MS Windows, Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.1 (apache2handler), mysql 5.0.37
0803
2007-05-04
 

6 Comments

pixtur

Jun 6, 2008
First thoughts
Hi Gerxiu...

I renamed you post and turned it into a bug.

Did you try to enter any Asian input onto this site? Maybe as a comment to this bug report? I saw that some Chinese characters in another post and wonder how they entered them...

guest

Jun 11, 2008
Trying to input some chinese characters
Thanks pixtur.

Here comes some Chinese characters, not sure whether it works:

中国,你好!

guest

Jun 11, 2008
It works on this site!!
Hi Pixtur,
It works on this site, how the system configured to support Chinese? would you please help to check? Thanks in advance!

Is there a Chinese version of Streber-pm existing yet? Please let me know if anything I could help. It's a very nice tool!

/Gerxiu

guest

Jun 11, 2008
Trying to input Japanese characters
日本ごが できますか。

guest

Jun 11, 2008
So
Basically, the Asian multi-byte characters working on this site, but not in my local server. no idea where to head ;p

/Gerxiu

pixtur

Jun 12, 2008
interesting...
Obviously this seems to be an encoding problem either. I remember that the database for this site went through some steps of conversion. I guess the mysql-server of database adaptor needs to be configured to support a working uft8 chain from the browser to database and back.

 

Comment / Update