RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-23 Thread Jerry Schwartz
The UTF-8 issue was the only thing that really concerned me at the time. I work for a multi-national based in Japan. Isn’t there a change log on the MySQL web site? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 8

Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-23 Thread Tompkins Neil
Hi Thanks for your quick response. Apart from the UTF-8 support, was there anything else we should consider. At the moment our system doesn't support UTF-8, so if this is the only concern/advantage of using ODBC 5.1, then maybe we should think about using MySQL 5 with ODBC 3.51. What are your t

Using IF in a query to set a variable then sort on said variable

2009-10-23 Thread Jeff
I currently have a query like so: SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId, d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM tblProspects as p LEFT JOIN tblProspectsDetails as d ON d.prospectId = p.fldId WHERE p.uId = "46437" ORDER BY d.

RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-23 Thread Jerry Schwartz
The key difference for me was the ability to handle UTF-8. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com >-Original Message- >From: Tompkins Neil [mailto:neil.tompk.

MySql Workbench 5.2.6 Alpha

2009-10-23 Thread Jo�o C�ndido de Souza Neto
I´m testing this tool and I got a small problem. When I export its diagram into a PDF or a PNG file, it does not put all tables in its right place, so my diagram image or pdf gets a complete mess placing its tables. PS: I´ve tried to put this in mysql-gui_tools before, so I got a reponse that