Converting BLOB to TEXT

[David Griffith]

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.