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.) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php