• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SQL command to display very long string

 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
pie sneak
Posts: 4727
Mac VI Editor Ruby
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Could you please post your problem a bit more clearly?
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Willie Smits increased rainfall 25% in three years by planting trees. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic