Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

--001485f19f12d6441a0476869148
Content-Type: text/plain; charset=ISO-8859-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

--001485f19f12d6441a0476869148--

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.tompkins@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=gcdmg-mysql-2@m.gmane.org

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

--0016363b9bf6f193c004769d55d1
Content-Type: text/plain; charset=ISO-8859-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
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.tompkins@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
>
>
>
>

--0016363b9bf6f193c004769d55d1--

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

------=_NextPart_000_038E_01CA53F4.F5E9DB30
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The UTF-8 issue was the only thing that really concerned me at the time. =
I work for a multi-national based in Japan.

=20

Isnâ€=99t there a change log on the MySQL web site?

=20

Regards,

=20

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

=20

860.674.8796 / FAX: 860.674.8341

=20

www.the-infoshop.com

=20

From: Tompkins Neil [mailto:neil.tompkins@googlemail.com]=20
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

=20

Hi

=20

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 ?

=20

Regards,

Neil

On Fri, Oct 23, 2009 at 3:18 PM, Jerry Schwartz =
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 =20


>-----Original Message-----
>From: Tompkins Neil [mailto:neil.tompkins@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=3D44935. Basically all my queries =
fail to
>return any string/varchar values.
>
>Thanks for any help.
>
>Regards,
>Neil




=20


------=_NextPart_000_038E_01CA53F4.F5E9DB30--

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

--001485f1e64a8eb8120476d330dc
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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
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=92t 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.tompkins@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 suppo=
rt
> 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 <
> jschwartz@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.tompkins@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 betwe=
en
> >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 wi=
th
> >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=3D44935. Basically all my queries fail=
to
> >return any string/varchar values.
> >
> >Thanks for any help.
> >
> >Regards,
> >Neil
>
>
>
>

--001485f1e64a8eb8120476d330dc--

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

>-----Original Message-----
>From: Tompkins Neil [mailto:neil.tompkins@googlemail.com]
>Sent: Monday, October 26, 2009 5:29 AM
>To: Jerry Schwartz
>Cc: [MySQL]
>Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1
>
>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 ?
>
[JS] I only use 5.1, so I can't tell you.
>Regards
>Neil
>
>
>On Fri, Oct 23, 2009 at 7:24 PM, Jerry Schwartz
>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.tompkins@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 <
>> jschwartz@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.tompkins@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=gcdmg-mysql-2@m.gmane.org