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:
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?
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.