Hi, Shawn Green Thanks for your reply. But I expect new version of MyODBC(one of mysql-connectors), not of mysqld. We now use mysql5.0. The newest version of MyODBC is 3.51.12.
Regards, gulei ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "古雷" <[EMAIL PROTECTED]> Cc: "MySQL List" <mysql@lists.mysql.com>; "Dušan Pavlica" <[EMAIL PROTECTED]> Sent: Wednesday, January 11, 2006 11:16 PM Subject: Re: How can I keep character_set_client value after MyODBC auto reconnect? >I wouldn't hold your breath for any new 3.xx releases or updates. MySQL AB > has moved through developing and releasing and almost retiring the 4.0.x > and 4.1.x versions of its server line and is actively promoting v5.0.x > while still working on v5.1.x. The 4.1.x version is being supported with > patches (if the issue still affects that versions) but I cannot remember > if 4.0 still is. No new features are planned for any versions lower than > 5 that I am aware of. I think now might be a good time to upgrade your > server. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > 古雷 <[EMAIL PROTECTED]> wrote on 01/10/2006 09:49:04 PM: > >> Thanks a lot. >> I needs SET AUTOCOMMIT=0, SET NAMES utf8 and SET TRANSACTION >> ISOLATION LEVEL READ COMMITTED after a new connection. >> Further more, MyODBC3.51.10 reconnects automatically when connection >> lost but MyODBC3.51.12 doesn't. >> I think automatic reconnection is not bad when it can keep >> variables' value or can give me a chance to run more than one SQL >> statement to init my session. >> >> Another question: when will new verison of MyODBC3.5 be released? >> One of our application often disconnect and connect MySQL and then >> MyODBC often core dump. >> >> Best regards, >> >> gulei >> ----- Original Message ----- >> From: "Dušan Pavlica" <[EMAIL PROTECTED]> >> To: "古雷" <[EMAIL PROTECTED]>; "MySQL List" <mysql@lists.mysql.com> >> Sent: Tuesday, January 10, 2006 6:34 PM >> Subject: Re: How can I keep character_set_client value after MyODBC >> auto reconnect? >> >> >> > Hi, >> > >> > did you try SET CHARACTER SET utf8 as Initial Statement under > Connection >> > Options of your MyODBC DSN? >> > HTH, >> > Dusan >> > ----- Original Message ----- >> > From: "古雷" <[EMAIL PROTECTED]> >> > To: "MySQL List" <mysql@lists.mysql.com> >> > Sent: Monday, January 09, 2006 10:19 AM >> > Subject: How can I keep character_set_client value after MyODBC auto >> > reconnect? >> > >> > >> >> Hello: >> >> >> >> I found that MyODBC use mysql_ping to check connection and reconnect. >> >> After reconnect by using mysql_ping character_set_client, >> >> character_set_connection and character_set_results go back to latin1. >> >> But I need them to be utf8. >> >> What can I do with MyODBC? >> >> >> >> Regards, >> >> >> >> gu lei >> >> >> >> 祝 事业有成,家庭和睦,身体健康,一切吉祥 >> >> >> >> 古雷 >> >> ------------------------------------------- >> >> 中企动力科技集团 >> >> 技术事业发展部___技术架构部 >> >> \__企业IP通讯部 >> >> 电话:010 58022278-302 >> >> 地址:北京亦庄经济技术开发区北工大软件园 >> >> (地盛北街1号)A区3号楼 >> >> 邮编:100176 >> >> >> > >