Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best Field Type

Status
Not open for further replies.
TheConeHead

TheConeHead

Programmer
Aug 14, 2002
2,106
US
What is the best field type if I want massive amounts of text... I am usually a varchar kin'a guy but that is limited to I think 255 chars... what is a good alternative for lots o' text?

[conehead]
 
Sort by date Sort by votes
just 'text' type will do in many cases

if you want to store megabytes of text in one record and field you must use 'blob'

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
385
bharons
bharons
Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
225
Andrzejek
Andrzejek
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
189
martinkaeser
martinkaeser
waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
372
SkipVought
S
gazza110
  • Locked
  • Question
Converting a single comma separated field into multiple rows
Replies
0
Views
98
gazza110
gazza110

Part and Inventory Search

Sponsor

Back
Top