database design

[nicknick]

Hi ,

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]

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]

You can use "Text", "MediumText", "LongText" depending on your requirement.
The Max. length of
Text - 65535
MediumText - 16777215
LongText - 4294967295

Hope this will help.