Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Comments on How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?
Post
How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?
+2
−0
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.
1 comment thread