|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
August 12th, 2003, 08:25 AM
|
||||
|
||||
|
data type for text input
what data type is best for a description of something? i'm building a help desk application, and need several fields to store information about the problem, solution, description, and comments. i'm thinking it should be varchar, but how big? should i go the full 8000? suggestions?
__________________
My brain cells are like a storm trooper's armor: useless
|
|
#2
August 12th, 2003, 09:31 PM
|
|||
|
|||
|
If you are going to use varchar using 8000 character size doesn't waste 8000 characters for short entries, varchar physically uses only what's necessary.
If you don't mind some extra baggage in some coding, you can use a text datatype which is virtually unlimited in size.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > data type for text input |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
 |
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
