MySQL Forums :: Database Administration & Monitoring :: Converting BLOB to TEXT

Advanced Search

Converting BLOB to TEXT
Posted by: David Griffith ()
Date: June 13, 2006 09:34AM


I have several BLOB columns in my database which I wish to convert to TEXT so that I can specify a character encoding. Everytime I try to use this command:


I get warnings on almost every row saying that 1265 - Data Truncated and it has lost a load of the data.

I want the data to display correctly using UTF8 character encoding. This all used to work fine but I think our server was upgraded to 4.1.19 and now it no longer works. I get all sorts of ? throughout the text where special characters should be.

Can anyone help?

Kind regards,

Options: ReplyQuote

Subject Written By Posted
Converting BLOB to TEXT David Griffith 06/13/2006 09:34AM
Re: Converting BLOB to TEXT Peter Naus 08/27/2007 01:13AM

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.