Thanks for the response Jerry. I suppose my main question is it possible/recommended to run ODBC 3.51 which version 5 of MySQL - or is it highly recommended to use ODBC 5.1 ?
Regards Neil On Fri, Oct 23, 2009 at 7:24 PM, Jerry Schwartz <jschwa...@the-infoshop.com>wrote: > 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 > > > >-----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 > > > >