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