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.)
Subject
Views
Written By
Posted
3226
February 28, 2010 09:52AM
Re: Problems with cyrillics on version 4.1.3
1699
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.