MySQL Forums
Forum List  »  PHP

Re: Encoding problem...
Posted by: Rick James
Date: August 08, 2010 06:16PM

Good news, the data seems to be properly stored as utf8.

If you always do mysql_query("SET NAMES 'utf8'") (local, staging, etc), the display will also be 'correct'. Yes?

Probably explanation of your previous post: One of the settings (probably character_set_results) on the staging server was not utf8, so MySQL converted the utf8 data to whatever the setting said, causing the gibberish.

Options: ReplyQuote


Subject
Written By
Posted
July 30, 2010 07:04AM
July 30, 2010 07:43AM
August 01, 2010 02:33PM
August 04, 2010 02:53PM
August 04, 2010 02:59PM
August 02, 2010 11:52AM
August 02, 2010 06:10PM
August 02, 2010 08:42PM
August 05, 2010 12:30AM
August 05, 2010 12:33AM
August 05, 2010 12:35AM
August 05, 2010 12:37AM
August 05, 2010 08:43AM
August 06, 2010 02:17PM
August 06, 2010 11:01PM
August 08, 2010 04:01PM
Re: Encoding problem...
August 08, 2010 06:16PM
August 05, 2010 12:40AM
September 01, 2010 12:53PM
September 01, 2010 10:50PM


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.