Link to home
Start Free TrialLog in
Avatar of nfuids
nfuids

asked on

MySQL

Which mysql field type can I use for text longer than 255 characters ?!
Avatar of lokeshv
lokeshv

use TEXT( max 65535 ) or LONGTEXT(max 4294967295)...


according to ur text char sieze..


Hope this helps..

Lk
Avatar of nfuids

ASKER

I just have to go like


CREATE TABLE tblName (FieldName TEXT(max 65535));

??
ASKER CERTIFIED SOLUTION
Avatar of lokeshv
lokeshv

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nfuids

ASKER

thanks a lot