MySQL Forums
Forum List  »  Newbie

BLOB to Text in mysql
Posted by: vissu pangam
Date: May 13, 2014 11:33PM

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

Options: ReplyQuote


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.