Answers for "mysql varchar length"

change varchar length mysql

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);

mysql varchar length

SELECT length('abcd') FROM DUAL;		-- Oracle
SELECT length('abcd');					-- MySql
SELECT len('abcd');						-- SQL Server

varchar max length

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

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.