Re: Problems with cyrillics on version 4.1.3
Posted by: Rick James
Date: March 01, 2010 04:05PM

SHOW CREATE TABLE

Do this immediately after connecting:
SET NAMES utf8

If you failed to do that when inserting the data, it may be garbled in the database. Pick a short word and do
SELECT word, HEX(word), LENGTH(word), CHAR_LENGTH(word)
FROM tbl WHERE ...
Then we can discuss whether the data in the table is messed up or not.

(Oh, please tell me what you expect the word to be; I am not versed in cyrillic.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problems with cyrillics on version 4.1.3
1695
March 01, 2010 04:05PM


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.