Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 698
  • Last Modified:

Mysql field length

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
johnhardy
Asked:
johnhardy
  • 2
  • 2
3 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
TEXT is the data type category you need to choose:
http://dev.mysql.com/doc/refman/5.0/en/blob.html
0
 
Mark BradyCommented:
I would use longtext for any large fields you need.
0
 
johnhardyAuthor Commented:
Thanks elvin66
Do I need to specify a length for longtext?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no. those data types are without "length" specification
0
 
johnhardyAuthor Commented:
Many thank for the quick answers

John
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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