BLOB to Text in mysql
I have a column in mysql which has the datatype BLOB.I am using crystal reports for some reports. My problem is BLOB column will show blank data if it contains data other than a picture. The data I am getting from DB is text only.So I want to convert the BLOB column to some other datatype which will occupy more data like BLOB object. Please suggest what datatype I can conevrt.
I tried this query but not working .Please help
SELECT CAST(key_initiatives AS MEDIUMTEXT) key_init FROM OBJSETTING_FOCUS_ON_CUSTOMER
Subject
Written By
Posted
BLOB to Text in mysql
May 13, 2014 11:33PM
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.