Re: [NF] What's wrong with this CAST call?

2012-01-24 Thread Ted Roche
On Tue, Jan 24, 2012 at 1:19 PM, Jarvis, Matthew 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

RE: [NF] What's wrong with this CAST call?

2012-01-24 Thread MB Software Solutions General Account
On Tue, January 24, 2012 1:19 pm, Jarvis, Matthew 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? Hi Matt,

RE: [NF] What's wrong with this CAST call?

2012-01-24 Thread Jarvis, Matthew
> > WTF?!?!? On more tests, it seems that I can't get it to cast to VARCHAR > or FLOAT types. > 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 y

RE: [NF] What's wrong with this CAST call?

2012-01-24 Thread MB Software Solutions General Account
On Tue, January 24, 2012 1:11 pm, Richard Kaye wrote: > Don't know if this has changed (apparently not) > > > http://bugs.mysql.com/bug.php?id=34564 > Thanks, Richard. Looks like I'll have to stick with CHAR for now. I'm using SQL Server scripts from a previous developer, and it's a PITA to ha

RE: [NF] What's wrong with this CAST call?

2012-01-24 Thread Richard Kaye
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 f

[NF] What's wrong with this CAST call?

2012-01-24 Thread MB Software Solutions General Account
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));