From: Kailash R
Date: October 15 2011 11:13pm
Subject: User defined Variables
List-Archive: http://lists.mysql.com/mysql/226063
Message-Id: <CABHt1zAkB5rhE4V3hAiqqmH8cjEAzrz55rCT6zLx-3O0=wG0oQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001636498f2be5cdf604af5e8603

--001636498f2be5cdf604af5e8603
Content-Type: text/plain; charset=ISO-8859-1

 I was wondering if there is a way to increase the size of user defined
variables ? I am not able to attribute a type to them and when I assign @sql
= 'a_text _field' , 'a_text_field' gets truncated if it exceeds the size of
@sql. This is not wholesome as I am using @sql in a subsequent prepare
statement and my procedure errors out with a sql syntax error. Any advice
for this would help.

thanks.

--001636498f2be5cdf604af5e8603--