MySql Workbench 5.2.6 Alpha
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 I´m not allowed to send messages there. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1
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...@googlemail.com] Sent: Thursday, October 22, 2009 10:04 AM To: [MySQL] Subject: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 Hi, We are currently running a early version of MySQL and are looking to upgrade to the latest version 5. However, we have a number of external applications which use the MySQL Connector/ODBC 3.51. What are the differences between ODBC 3.51 and ODBC 5.1. For example do I need to use ODBC 5.1 if we upgrade our database to version 5 or can I continue using ODBC 3.51. I carried out some limited tests and found that ODBC 3.51 worked fine with MySQL database version 5. However, if I use ODBC 5.1 with MySQL version 5 I have a very strange problem as documented here : http://bugs.mysql.com/bug.php?id=44935. Basically all my queries fail to return any string/varchar values. Thanks for any help. Regards, Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Using IF in a query to set a variable then sort on said variable
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.lastDate ASC, d.timezoneId DESC Basically I have been trying several ways to get this set up to work but due to the way the timezones are set up in this system, a regular sort won't work. What I want to know is, is it possible to check the value of field and set a variable, then sort on that. For example: IF d.timezone = 5 THEN @tempzone = 1 Then sort the entire query on that tempzone. Basically what I want to do is test the timezone ids versus a few numbers, assign them a value and sort on that. IF d.timezone = (1,3,5,8) THEN @tempzone = 1 (pseudo code) Is this possible in a mySQL query directly? The only other option I guess I have is to run a mass update on a field then doing the normal order but doing three updates just to make one select work seems kind of unfortunate :( Jeff
Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1
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 thoughts on this ? Regards, Neil On Fri, Oct 23, 2009 at 3:18 PM, Jerry Schwartz jschwa...@the-infoshop.comwrote: 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...@googlemail.com] Sent: Thursday, October 22, 2009 10:04 AM To: [MySQL] Subject: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 Hi, We are currently running a early version of MySQL and are looking to upgrade to the latest version 5. However, we have a number of external applications which use the MySQL Connector/ODBC 3.51. What are the differences between ODBC 3.51 and ODBC 5.1. For example do I need to use ODBC 5.1 if we upgrade our database to version 5 or can I continue using ODBC 3.51. I carried out some limited tests and found that ODBC 3.51 worked fine with MySQL database version 5. However, if I use ODBC 5.1 with MySQL version 5 I have a very strange problem as documented here : http://bugs.mysql.com/bug.php?id=44935. Basically all my queries fail to return any string/varchar values. Thanks for any help. Regards, Neil
RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1
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 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Friday, October 23, 2009 1:14 PM To: Jerry Schwartz Cc: [MySQL] Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 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 thoughts on this ? Regards, Neil On Fri, Oct 23, 2009 at 3:18 PM, Jerry Schwartz jschwa...@the-infoshop.com wrote: 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 http://www.the-infoshop.com/ -Original Message- From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Thursday, October 22, 2009 10:04 AM To: [MySQL] Subject: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 Hi, We are currently running a early version of MySQL and are looking to upgrade to the latest version 5. However, we have a number of external applications which use the MySQL Connector/ODBC 3.51. What are the differences between ODBC 3.51 and ODBC 5.1. For example do I need to use ODBC 5.1 if we upgrade our database to version 5 or can I continue using ODBC 3.51. I carried out some limited tests and found that ODBC 3.51 worked fine with MySQL database version 5. However, if I use ODBC 5.1 with MySQL version 5 I have a very strange problem as documented here : http://bugs.mysql.com/bug.php?id=44935. Basically all my queries fail to return any string/varchar values. Thanks for any help. Regards, Neil