Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

infinite positions for column

 
Candy Bortniker
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a textfield that is a scrollpane that allows for a description to be entered, this could have an infinite amount of characters. How would I set that up when I create the table to allow for any amount of characters? Or can I do that?
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Depends on the Database you are using. MySQL has a TEXT data type. It will probably be what you want to use. There are constraints on any data type in any database. Even if it just comes down to the allowed memory size of the table itself. Here is a list of data types and their storage limitations for MySQL. If you aren't using MySQL let me know and I will try and located info on your DB.
 
Adrian Yan
Ranch Hand
Posts: 688
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually, Candy, you need to set your requirement a little better. Your requirement should'nt say infinite, because the obviously no-one is gonna type in infinite amount of characters. You should set the description to whatever your database allow, and in your appliaction, check for the number of characters and give the user indication of amount allow.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic