Forums

Having both English and Chinese characters in site name?

Permalink
Is it possible to have both English and Chinese characters in site name?

I have an English version of c5 installed 3 hours ago (ie, I am a novice). When I tried to enter double-byte Chinese characters in site name (to replace the default name "My Site"), they all show up as question marks - "?". English letters show up without problem of course.

What should I do to have both English and Chinese characters displayed properly? Should I install Chinese version of c5?

Thanks
csc
 
jbx replied on at Permalink Reply
jbx
Your database needs to be setup to use utf-8. How did you install C5? Did you create the database yourself using phpMyAdmin?

Jon
csc replied on at Permalink Reply
Jon,

Thanks, it is a good hint. I am trying to use C5 as CMS on bluehost. In the C5 installation process on bluehost, I checked the box to have a database automatically created. So I have no control of what encoding to use. Do you know how to fix it?

Thanks
csc
csc replied on at Permalink Best Answer Reply
Actually, a solution is in the following thread:

http://www.concrete5.org/community/forums/internationalization/simp...

From PHPMyAdmin (usually through cPanel):
1. Select the Database (from the left)
2. Click on Operations tab (top right)
3. Goto Collation (at the bottom)
4. Select 'utf8_unicode_ci' and click Go
editfish replied on at Permalink Reply
Awesome, thank you very much! Works perfectly!!!