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...>.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Storing Hebrew strings Ok, but gibberish when pulling data on another server
2355
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.