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

SQL command to display very long string

 
Sam Zou
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a column in a table which holds a general comment of 10000 characters maximum.
When I do a select command on the DB shell I cannot have the whole comment but only the first 3 lines ?
Is there a string type that can hava variable length ? I mean I didn't have to specify it length when the table is created ?
Thanks
 
Marc Peabody
pie sneak
Sheriff
Posts: 4727
Mac Ruby VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you please post your problem a bit more clearly?
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sam,

When I do a select command on the DB shell I cannot have the whole comment but only the first 3 lines ?

Is this a question (or a statement)?
What is "DB shell"?

Is there a string type that can hava variable length ? I mean I didn't have to specify it length when the table is created ?

Yes there is. Most databases define a very large text datatype -- usually called CLOB (Character Large OBject).
But seeing as I saw no mention in your post about what database you are using, I can't tell you if it has a CLOB datatype (or not). So would you like to look it up in your database's documentation? Or would you like to tell me what database you are using? [And I can look it up for you ;-]
Hope this has helped you.
Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic