varchar lengts code example

Example 1: varchar max length

TINYTEXT              255
TEXT/VARCHAR          65,535
MEDIUMTEXT    	      16,777,215
LONGTEXT              4,294967,295

Example 2: varchar max length

65,535

The length can be specified as a value from 0 to 65,535. 
The effective maximum length of a VARCHAR is subject to 
the maximum row size (65,535 bytes, which is shared among all columns) 
and the character set used.