MySQL: Windows v Linux

Posted by: scoopseven 18 years ago

I beat my head against my desk once already, and I'm sure it'll happen at least once more finding out about the differences between MySQL running on a Windows 2003 Enterprise server and a Mindrake Linux 1o.o server. In one of my applications I'm setting a default variable, thisMonth, to a null string. The target column is defined as an integer. When I do the insert into my table i use single quotes around my variable, even though it's an int. Although this may not be a best practice it works fine when my variable isn't defined and I want to insert a null value into thisMonth... on the linux server anyway. Running the exact same query on the Windows server produces an invalid datatype error. At first I thought this had something to do with a MySQL ODBC driver, or maybe the way ColdFusion handles the driver. I was able to rule both of those out though by running the queries through MySQL Front. Same result. Worked fine on the Linux server, errored on the Windows server. Fixing the problem by changing the default value of my variable. But I definitely thought this was worth the mention. Share on Twitter Share on Facebook

• ← Sorbs Sucks
• Installing MySQL JDBC driver for ColdFusion MX 6.1 →