Solved

MySQL

Posted on 2002-05-13
4
233 Views
Last Modified: 2008-03-06
Which mysql field type can I use for text longer than 255 characters ?!
0
Comment
Question by:nfuids
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

749 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