1SELECT length('abcd') FROM DUAL; -- Oracle
2SELECT length('abcd'); -- MySql
3SELECT len('abcd'); -- SQL Server
165,535
2
3The length can be specified as a value from 0 to 65,535.
4The effective maximum length of a VARCHAR is subject to
5the maximum row size (65,535 bytes, which is shared among all columns)
6and the character set used.