What type of character (varchar , bigint , int) must i use if i want to put a paragraph of text in a database and how long must it be ?
cheers
phranque
11:21 am on Aug 19, 2008 (gmt 0)
it depends on which db you are using but normally there is a "text" data type that is suitable for that purpose and it can typically be thousands of characters or more, usually 4K-64K.
IndiaMaster
11:25 am on Aug 19, 2008 (gmt 0)
You can use "Text", "MediumText", "LongText" depending on your requirement. The Max. length of Text - 65535 MediumText - 16777215 LongText - 4294967295
