On Tue, Jan 24, 2012 at 1:19 PM, Jarvis, Matthew <mat...@mckweb.com> wrote:
> Well, let me ask the dumb question - does Maria (some day I should tell > you about my ex Maria - oh boy...) DB support the VARCHAR syntax in the > first place? Do you use that syntax anywhere else in your > testing/application? There are no dumb questions ;) MySQL and it's spin-offs do support varchar, but the CAST() and CONVERT() functions don't: http://dev.mysql.com/doc/refman/5.1/en/cast-functions.html#function_cast "The CONVERT() and CAST() functions take a value of one type and produce a value of another type. The type can be one of the following values: BINARY[(N)] CHAR[(N)] DATE DATETIME DECIMAL[(M[,D])] SIGNED [INTEGER] TIME UNSIGNED [INTEGER]" Whether that's a bug or a "by design" implementation issue, you'll have to take up with the developers. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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/CACW6n4s4-Z=uz15bxgekyp6kyr9qhcyaxmfa80zeq6haxzh...@mail.gmail.com ** 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.
