Is it possible to split the content of Blob Datafield?

[xtremebass]

Hi.

Is it Possible to separate contents present in Blob Datafiled?

[r035198x]

Not using MySQL. Why would you want to do that?

[xtremebass]

Thanks for reply.
Actually i have stored long text in my blob field,and that long text contains line n\by line inputs like below ,

name: xx
No:yy
subject:xyz
Class:abc
Marks: 123

so when i am retrieving these values to Browser in Jsp contents can present in the blob filed displayed like this. name:xxno:yysubject:xyzclass:abcmarks:123.

this is what the problem i am facing right now.

so i want to display the contents of blob field as it stored in the table .

Any idea about this problem..

[r035198x]

1.) Your structure doesn't look right. You are storing many things in one column instead of splitting all that into separate columns. Read about normalization.
2.) Long text should be stored in a CLOB rather than a BLOB field.
3.) You need to replace all the \n with <br /> for that to display correctly. Just use String's replaceAll method for that.