MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Storing Hebrew strings Ok, but gibberish when pulling data on another server
Posted by: Rick James
Date: February 03, 2010 08:52PM

There are many places that it could be wrong. There could even be two wrongs making a right.

Immediately after any programmatic connection, do
SET NAMES utf8;

If you are using mysqldump, be sure to have the appropriate utf8 options on it.

When loading the data on another machine either have the database (my.cnf/my.ini) defaulting to utf8 and/or make sure the loading script (eg from mysqldump) has utf8 set.

When displaying in a browser, be sure to use <meta...utf8...>.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Storing Hebrew strings Ok, but gibberish when pulling data on another server
7997
Joseph E
February 02, 2010 08:06AM
Re: Storing Hebrew strings Ok, but gibberish when pulling data on another server
2648
Joseph E
February 02, 2010 02:40PM
Re: Storing Hebrew strings Ok, but gibberish when pulling data on another server
2326
Rick James
February 03, 2010 08:52PM


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.