What is the maximum range of varchar in MySQL?

mysql varchar sqldatatypes
Deviprasad Das picture Deviprasad Das · May 6, 2011 · Viewed 18.2k times · Source

What is the maximum range of varchar in MySQL?

I am using the latest version of MySQL and in many sites it is being told that the size is 255. But when i am trying to give a higher size like 500 or 1000, it works for me. So is there a maximum number for varchar datatype?

Answer

Bozho picture Bozho · May 6, 2011

It was 255 before 5.0.3, but now:

Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 65,535.

The documentation of 5.0.x shows the transition:

Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.

Related questions

#1054 - Unknown column

I am using MySQL 5.5 and phpmyadmin 3.5.2 (provided by http://www.freewebhostingarea.com) My sql query is: INSERT INTO `example`(`id`, `name`, `password`) VALUES (1,we,5) where id is int type, name and password are varchar. but when ever inserting any value …

Read More
#1071 - Specified key was too long; max key length is 767 bytes

When I executed the following command: ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` ); I got this error message: #1071 - Specified key was too long; max key length is 767 bytes Information about column1 and column2: column1 varchar(20) utf8_general_ci column2 …

Read More
What is the MySQL VARCHAR max size?

I would like to know what the max size is for a MySQL VARCHAR type. I read that the max size is limited by the row size which is about 65k. I tried setting the field to varchar(20000) but it …

Read More