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 >> >