469,090 Members | 1,296 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Is it possible to split the content of Blob Datafield?

Hi.

Is it Possible to separate contents present in Blob Datafiled?
Nov 14 '08 #1
3 2198
r035198x
13,262 8TB
Not using MySQL. Why would you want to do that?
Nov 14 '08 #2
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..
Nov 18 '08 #3
r035198x
13,262 8TB
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.
Nov 18 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Carolyn Longfoot | last post: by
1 post views Thread by lonelyplanet999 | last post: by
4 posts views Thread by Brian Glen Palicia | last post: by
2 posts views Thread by rooster575 | last post: by
9 posts views Thread by Wayne Smith | last post: by
3 posts views Thread by deepaa | last post: by
3 posts views Thread by MikeB | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.