Re: Can not get proper utf8 text

[Robert Lee]

Thanks for the response and the link you provided.

The table I'm trying to access is a website user list. Users enter their information through a registration form page.

The site is created by some Chinese web design company (using Zend framework) and also hosted now on some server there. I don't believe they (the original developer) did anything fancy for the site, though I'm not totally sure.

The site has a backend page for screening user accounts. On this page, all utf8 text fields show up fine.

Personally I know very little about PHP or MySQL. I do have FTP access to the site and have downloaded all the files from the site. I did briefly browser through those files, but could not find MySQL configuration file.

An example:
One user's first name in Japanese: 内間
It should be only 2 characters.

But, the query result shows:
- member_firstname: 内間
- HEX(member_firstname): C3A5E280A0E280A6C3A9E28093E2809C
- LENGTH(member_firstname): 16
- CHAR_LENGTH(member_firstname): 6


Bob



Edited 2 time(s). Last edit at 06/08/2011 10:46AM by Robert Lee.