Solved

MySQL

Posted on 2002-05-13
4
231 Views
Last Modified: 2008-03-06
Which mysql field type can I use for text longer than 255 characters ?!
0
Comment
Question by:nfuids
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:lokeshv
ID: 7005858
use TEXT( max 65535 ) or LONGTEXT(max 4294967295)...


according to ur text char sieze..


Hope this helps..

Lk
0
 

Author Comment

by:nfuids
ID: 7005862
I just have to go like


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

??
0
 
LVL 4

Accepted Solution

by:
lokeshv earned 50 total points
ID: 7005879
just speccify "TEXT" ..

like..


CREATE TABLE tblName (FieldName TEXT);


LK
0
 

Author Comment

by:nfuids
ID: 7005889
thanks a lot
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question