Don't know if this has changed (apparently not) http://bugs.mysql.com/bug.php?id=34564
-- rk -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions General Account Sent: Tuesday, January 24, 2012 1:06 PM To: profoxt...@leafe.com Subject: [NF] What's wrong with this CAST call? MySQL (well, actually MariaDB via HeidiSQL IDE) For some reason, I'm having a problem getting a field cast as a varchar in my sql. I'm trying this: select CAST('test' as varchar(255)); ...and it fails saying I have an error in syntax. I can do this just fine: select CAST('test' as char(255)); WTF?!?!? On more tests, it seems that I can't get it to cast to VARCHAR or FLOAT types. Is there something obvious here that I'm missing? tia, --Mike _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0441D4A7D5965@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
