472,127 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

Is it possible to split the content of Blob Datafield?


Is it Possible to separate contents present in Blob Datafiled?
Nov 14 '08 #1
3 2245
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
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
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.