At 10:12 -0400 4/26/02, Jerry Jackson wrote:
>I apologize if this is a repost, but I've been having problems with my mail
>servers and don't know for sure what has gone out or come in recently.
>I am hoping someone can shed light on this for me. We have a fairly simple
>query that is pulling data from varchar(255) and integer(11) fields and
>concatenating the field contents into a single results column. The problem
>is the resulting data is reported to be BLOB instead of the expected
>concatenated string....which in turn is causing our application to complain
>about an unsupported data type (our application is expecting a string value
>to be returned). It seems like an error in MySQL to us.
The maximum length of a CHAR or VARCHAR is 255 characters. If you create
a string longer than that, it can't be CHAR or VARCHAR. MySQL uses the next
smallest string type large enough to hold the result: BLOB. (At least,
that's what I suspect is happening.)