[Resolved] the maximum chars which i can store in a table field

[Fking]

i'm writing interface for adding news on a site
the news lenght will vary a lot, i need to know what's the maximum of the chars which i can store, and what to do if it is not enough

[chyan]

it depent on what data type do you used
example if you are using VARCHAR data type, it could be up to 255 character

you can using blob or text to store long charachter

The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffer

[Fking]

so, the text which i can store in one mysql table field (cell) , is unlimited?

[laserlight]

Not quite.
For example, on MySQL the TEXT column type is limited to 2**16-1= 65535 characters.

[Fking]

that's what i need to know
thanks!