Reading Blob datatype

[Anon]

An attribute in my table is of the datatype blob,comprising of text as well as jpg files.I need to find a way to retrieve only the text part.Any feedback for the same will be highly appreciated.

[lawnmowerman]

So you have a blob column and either text or binary data could be stored in this column?

If that is the case, you'll probably need another column describing what type of data is stored in the single blob column.

-Rich

[Anon]

Sir
I want to insert files in my database type blob.
i create d table like this

create table ff(filename blob);
what i want is if i select file and then enter submit button then that file should inserted in this table named ff.
so pls give me idea.

i want inserted files can u mail me one sample program
how to insert files using blob data type on servlets.