• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

MySQL

Which mysql field type can I use for text longer than 255 characters ?!
0
nfuids
Asked:
nfuids
  • 2
  • 2
1 Solution
 
lokeshvCommented:
use TEXT( max 65535 ) or LONGTEXT(max 4294967295)...


according to ur text char sieze..


Hope this helps..

Lk
0
 
nfuidsAuthor Commented:
I just have to go like


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

??
0
 
lokeshvCommented:
just speccify "TEXT" ..

like..


CREATE TABLE tblName (FieldName TEXT);


LK
0
 
nfuidsAuthor Commented:
thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now