Re: Problem with Hebrew Strings
Posted by: Rick James
Date: April 11, 2010 10:39PM

You should probably leave this one binary:
character_set_filesystem | binary

Let's first see if the data was inserted correctly...
SELECT x, HEX(x), LENGTH(x), CHAR_LENGTH(x) ...
for some should Hebrew cells. I would expect proper utf8 encoding of all-Hebrew characters to have LENGTH = 2 * CHAR_LENGTH. (Note: any spaces or punctuation would not be doubled in length.)

What display mechanism are you using? The command line 'mysql' is at the mercy of the OS, which probably does not understand utf8.

Options: ReplyQuote


Subject
Views
Written By
Posted
3729
April 09, 2010 10:38PM
Re: Problem with Hebrew Strings
1934
April 11, 2010 10:39PM


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.