View Single Post
Old 07-06-07, 10:40 AM   #2
Ngemu Mod
Join Date: Jul 2003
Location: Fresno, CA
Posts: 1,886
Default Re: Storing Text Area into MySQL Database...

If you want to limit text, you should use a char type field. This will allow you to limit the characters inputted to a maximum of 255 characters. Text fields in mysql are limited to 65kb. There are other larger type text fields in mysql as well. Of course you could also use php or javascript to check and keep the posted string at a certain size before adding them into the table.
[i7 2600k @4.4ghertz][2x4 GB DDR3 1600][EVGA GTX570 1.280GB SC][EVGA GTX460 physx][Asrock Extreme7 Gen3 Z68][2xSeagate 160 Gb SATA HD raid0][Seagate 250 GB SATA2 HD][Sony Bravia 40' 1080p LCD HDTV][NEC 3520a DVD+-DLw][Windows 7 Ultimate x64][Rosewill 1000w]
fivefeet8 is offline   Reply With Quote