Solved

Mysql field length

Posted on 2013-01-24
5
648 Views
Last Modified: 2013-01-24
I am using mysql through Navicat.

I have a form field where a user can enter up to 10,000 characters
Can you say which field would be best to use. At the moment I am using varchar 750.

Thanks for any help.
Regards
John
0
Comment
Question by:johnhardy
  • 2
  • 2
5 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 325 total points
ID: 38813895
TEXT is the data type category you need to choose:
http://dev.mysql.com/doc/refman/5.0/en/blob.html
0
 
LVL 20

Assisted Solution

by:Mark Brady
Mark Brady earned 175 total points
ID: 38814037
I would use longtext for any large fields you need.
0
 

Author Comment

by:johnhardy
ID: 38814350
Thanks elvin66
Do I need to specify a length for longtext?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 325 total points
ID: 38814477
no. those data types are without "length" specification
0
 

Author Closing Comment

by:johnhardy
ID: 38814861
Many thank for the quick answers

John
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
The viewer will learn how to dynamically set the form action using jQuery.
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 …

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now