Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need to save a paragraph in database.

 
Kunal Lakhani
Ranch Hand
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a requirement to persist A paragraph of 10 lines in database. Is it possible?
If yes, how?
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is "a paragraph" - just plain text? That's what varchar fields are for in databases.
 
Kunal Lakhani
Ranch Hand
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using a html for input. Using string i can't persist them in database
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not? HTML is just text.
 
sourabh kanoongo
Greenhorn
Posts: 15
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it will definitely work..as said above.

if you are using mysql database then you can try using blob datatype of that concerned field in which you are storing paragraph.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sourabh kanoongo wrote:iif you are using mysql database then you can try using blob datatype of that concerned field in which you are storing paragraph.

Wouldn't you use a CLOB instead of BLOB since it text/html is character data and not binary data?
 
sourabh kanoongo
Greenhorn
Posts: 15
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok i will study more about CLOB and BLOB. thank you
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic