Re: Converting multilingual text from binary to text utf8
Posted by: Rick James
Date: July 29, 2010 12:15AM

"multilingual data" -- Is it all _encoded_ in utf8?

Some techniques to try:

* UPDATE foo SET text_field = UNHEX(HEX(blob_field));

* Use mysqldump to dump the blob, but use the hex option for it. Then...

* Use
ALTER TABLE foo MODIFY COLUMN blob_field TEXT NOT NULL CHARSET utf8;
It may take more than one ALTER, and it may involve going through latin1 (which seems to not care what the bytes are). Note: most conversions honor CHARSET, but going to or from a BLOB will not do any conversions.

Let me know what works.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Converting multilingual text from binary to text utf8
2494
July 29, 2010 12:15AM


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.