MySQL Forums
Forum List  »  Newbie

Re: Can not get proper utf8 text
Posted by: Robert Lee
Date: June 08, 2011 09:25AM

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


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

Options: ReplyQuote

Written By
Re: Can not get proper utf8 text
June 08, 2011 09:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.