How to read Chinese characters from MySQL database [message #38652] |
Wed, 22 August 2007 10:11 |
nectar2
Messages: 26 Registered: April 2005
Karma:
|
Junior Member |
|
|
Dear,
I did these:
- Installed latest FUDform with chinese language
- Set utf8 via 'MySQL Charset Changer'
- Everything looks like fine, FUDforum's interface is Chinese and I can post or read via broswer
- Then login phpMyAdmin to see whether it is ok on the MySQL side
- Browse to 'fud26_forum', there are some characters which can be read by human (as attachment show) on 'name' and 'descr' column, and it should be typed Chinese characters
- Used 'mysqldump' to export the database, open .sql file with text editor, as the same previously
Question:
1. What can 'MySQL Charset Changer' do? Just set exist table to specify collation? Is it possible using 'set names(utf8)' to solve this problem?
2. When I tried to modify the un-read characters to be read via phpMyAdmin, FUDforum display modified characters as '????'
(member) post Chinese characters[read] => (FUDforum) submit to MySQL=> (MySQL) store data[un-read] => (FUDforum) display Characters to visitor[read]
[Updated on: Wed, 22 August 2007 10:12] Report message to a moderator
|
|
|