Re: utf8_unicode_ci with multilingual content column
Posted by: Rick James
Date: April 05, 2010 08:03PM

How about SET NAMES utf8 when INSERTing?

SELECT x, HEX(x), LENGTH(x), CHAR_LENGTH(x) FROM tbl WHERE ...
Where x is the column containing Habo and the WHERE clause picks the appropriate row.
If the data is inserted as utf8, I would expect LENGTH=5 and CHAR_LENGTH=4.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: utf8_unicode_ci with multilingual content column
1708
April 05, 2010 08:03PM


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.