Geek asks and answers

What is the next best after VARCHAR (255)

I have a table with approximately 2 million records. I have a field called a message that is configured as varchar (160) and I need something larger than varchar (255) because I need to be able to store about 500 characters in it, which is the next best data type to use without increasing db size dramatically?

thank

+3
source share
3 answers

Starting with MySQL 5.0.3 , you can just use VARCHAR(500).

M represents the maximum column length in characters. In MySQL 5.0, the range of M is from 0 to 255 to MySQL 5.0.3 and from 0 to 65535 in MySQL 5.0.3 and later.

+5
source

5.0.3 , varchar 65535 .

11.4.1. CHAR VARCHAR

MySQL: VARCHAR TEXT

+3

TEXT,

which offers optimal data types for each column, which can help reduce the size of tables.

0
source

More articles:


All Articles