Error with "character_set_results"

Error with "character_set_results"

am 20.05.2010 00:12:55 von omarmun

Hi there, I'm testing ODBC 5.1. to connect to a server with 4.0. While=
defining ODBC Source and testing, it sends message "Connection Failed: [HY=
000][MySQL][ODBC 5.1 Driver]Unknown system variable 'character_set_results'=
". What should I do in order to fix it? Should I declare variable on O.S. o=
r somewhere else? Thanks in advance Omar =0A

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: Error with "character_set_results"

am 21.05.2010 05:44:36 von Lawrin Novitsky

Omar,

ODBC 5.1 doesn't work with servers < 4.1.1. That fact is reflected in
documentation.
Current trunk version would explicitly say that at attempt to connect to
such server.

Regards,
Lawrin Novitsky

Omar Muñoz wrote:
> Hi there,
>
> I'm testing ODBC 5.1. to connect to a server with 4.0. While defining ODBC Source and testing, it sends message "Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Unknown system variable 'character_set_results'". What should I do in order to fix it? Should I declare variable on O.S. or somewhere else?
>
> Thanks in advance
>
> Omar
>
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=lawrin@sun.com
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Error with "character_set_results"

am 21.05.2010 09:07:03 von Lawrin Novitsky

Forgot to add - if you really can't update your server, then the only
option is to use c/odbc v3.51

regards,
lawrin

Omar Muñoz wrote:
> Hi there,
>
> I'm testing ODBC 5.1. to connect to a server with 4.0. While defining ODBC Source and testing, it sends message "Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Unknown system variable 'character_set_results'". What should I do in order to fix it? Should I declare variable on O.S. or somewhere else?
>
> Thanks in advance
>
> Omar
>
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=lawrin@sun.com
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Error with "character_set_results"

am 21.05.2010 16:35:00 von Shawn Green

Omar Mu=F1oz wrote:
> Hi there,
>=20
> I'm testing ODBC 5.1. to connect to a server with 4.0. While defining O=
DBC Source and testing, it sends message "Connection Failed: [HY000][MySQ=
L][ODBC 5.1 Driver]Unknown system variable 'character_set_results'". What=
should I do in order to fix it? Should I declare variable on O.S. or som=
ewhere else?
>=20
> Thanks in advance
>=20
> Omar=20
>=20
>=20
>=20
>=20
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dshawn@mysql.co=
m
>=20

Character sets were improved in MySQL with version 4.1.
http://dev.mysql.com/doc/refman/4.1/en/charset.html

That particular variable did not exist prior to version 4.1.1 .
http://dev.mysql.com/doc/refman/4.1/en/server-system-variabl es.html#sysva=
r_character_set_results

--=20
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: Error with "character_set_results"

am 21.05.2010 19:57:51 von Jerry Schwartz

>-----Original Message-----
>From: Lawrenty.Novitsky@Sun.COM [mailto:Lawrenty.Novitsky@Sun.COM]
>Sent: Friday, May 21, 2010 3:07 AM
>To: Omar Muñoz
>Cc: myodbc@lists.mysql.com
>Subject: Re: Error with 'character_set_results'
>
>Forgot to add - if you really can't update your server, then the only
>option is to use c/odbc v3.51
>
[JS] Which will not handle UTF.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com







--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org