BLOB conversion

bshkris · New User Joined: 21 Mar 2005 Posts: 41 Location: pune

I have one question on BLOB conversion.

Is it possible to move VARCHAR data into varaible(column) which declared as BLOB in a table? The VARCHAR variable contains the non English data, and I want to display on the screen as an Image. So I must need to convert the data into as BLOB data first and after I can pull it from table and make it as an attachment to view by using some procedure which already available in the system .

Please clarify me kindly. Thank you very much.

dbzTHEdinosauer · Posted: Wed Jul 28, 2010 4:02 pm

is the varchar FOR BIT DATA?
when you say conversion, do you mean a CAST,
or select into host variable from varchar, and then insert from host var into BLOB?

bshkris · New User Joined: 21 Mar 2005 Posts: 41 Location: pune

I mean, I need to select the varchar data from table, and need to insert into column which declared as BLOB.

dbzTHEdinosauer · Posted: Thu Jul 29, 2010 1:13 pm

is the varchar FOR BIT DATA?