How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?
In a stored procedure let's say I have a VARCHAR variable,
DECLARE example_variable VARCHAR(100);
how much memory is allocated to it and is that independent of the length of the data in the variable?
The reason I ask is that I had a stored procedure that would run out of memory until I trimmed the VARCHAR lengths down. The actual data inside the variable never changed only the declared size.