Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By ming_lapurd on
My problem is not about translation but I guess this froum might be a good place to get some help.
I enabled the local module, added/enabled simplified Chinese language and chose it in the language field of the content. The Chinese characters get displayed in the preview mode, but they became unrecognizable after submission(actually, they turned into questions marks).
Did I overlook anything? Need to configure something else?
It is 3 in the morning and I am really beaten-up.
Any suggestion will be appreciated.
Comments
UTF8
Check your web browser - is it UTF8, or is it Simplified Chinese enabled....
By default, a Drupal theme template is set to utf8, so check also page.tpl.php of your theme
gb2312
I did set the charset of the pages as gb2312 (Chinese) but this did not solve the problem. I then checked the settings of mySQL and found the charset in use is utf8.
So my question is: shall I set the charset of mySQL to gb2312 as well?
I tried to change it to gb2312 but did not figure it out.
Collation of tables
I just found that the Collation of many of the database tables is latin1_swedish_ci. This might be due to the Fantastico installation.
Then I changed the node and node_revision tables' collation to something like utf_unicode, but this did not solve my problem.
Mass replacement of latin1 with ut8
Right, it might also because of database collation
U only change latin1 to utf8
*Did not solve the problem? Might because all tables are latin1. Profile values for example, are viewable but when you want to edit it, you get nothing (happened before)
Safer way is to BACKUP your database, then perform the mass replacement (latin1 = utf8 ) in ALL TABLES not just node* tables since you will get problems later on
*Use a plain-text editor, use the editor's replace all command
OR, you might want to install manually instead of relying on Fantastico-installed Drupal
So another safer way is to keep your existing site intact. Keep your existing database intact.
Install manually in a folder, named `drupal'. Create a new database and let Drupal (5.3) install itself first. Then you can start IMPORTING the backup database (which has been changed to utf8)
When you are satisfied (problem solved), you can MOVE the existing problematic site to a folder named `drupalxx' and move the new one to public_html (main site)
Chinese Text translation is not displaying correctly.
Hi All,
I am using the below modules:
-> Translation Framework
-> Node Translation
-> Google Translations
I have tried this way even, but there is not affect.
When I try to translate the English text to Chinese text, the Chinese text is display in the below format...
���벻����-Ӣ��������ģ����
I have
changed Browser settings to UTF-8.
changed database charset to utf-8
but no affect on the page.
When I write an individual/separate page code to translate the English to Chinese, it is working... but not on drupal v6.x.
I am not sure what might be the problem. Help me out to resolve this problem.
Anyone who see this post can help me? Any suggestions are welcome?
Thanks in advance,
Narendra