Re: What is the limit on VARCHAR storage in a procedure

[Roland Bouman]

see the reference:

http://dev.mysql.com/doc/mysql/en/char.html

Values in VARCHAR columns are variable-length strings. The length can be specified as 1 to 255 before MySQL 4.0.2, 0 to 255 as of MySQL 4.0.2, and 0 to 65,535 as of MySQL 5.0.3. (The maximum actual length of a VARCHAR in MySQL 5.0 is determined by the maximum row size and the character set you use. The maximum effective length is 65,532 bytes.)

I believe there is no difference between table column varchars and varchar variables in stored procedures.



Edited 1 time(s). Last edit at 07/30/2005 11:52AM by Roland Bouman.