1

I have a database column that will be storing errors/warnings returned from an API - I would usually have a column called 'description' with a varchar(255) but in some (very few cases) this column may need to store a value that is greater than 255 characters (potentially upto 400-500 characters).

This field won't need any ability to search or anything like that, can anyone suggest the best MySQL data type to use for this instance. This will store text and nothing else.

I would presume text - but just wondered what everyone else thought.

Zabs
  • 13,852
  • 45
  • 173
  • 297

1 Answers1

0

You can use varchar(500) for newer versions.

What is the MySQL VARCHAR max size?

Community
  • 1
  • 1
Adarsh Gangadharan
  • 653
  • 4
  • 10
  • ok cool didn't realise this had changed from 255 (thought it would be 255 forever lol) – Zabs Nov 02 '15 at 16:06