Solved

Mysql field length

Posted on 2013-01-24
5
653 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

770 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