Skip navigation links

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

HI,

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:

ALTER TABLE PRODUCT_TEXT MODIFY TEXT CHARACTER SET UTF8;

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,
David.

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.