我在VC中通过CADODatabase接口类访问mysql库,使用mysql站点下载的oledb3.0连接,可以成功连接,并执行查询语句。连接串:Provider=MySQLProv;Location=服务器ip;Data Source=数据库名;User Id=xxx;Password=xxxxx现在想在程序中执行一条插入语句,发现字段值为中文时,执行sql会出错,改为英文可成功。分析是由于mysql与vc的编码不兼容的缘故,请问大家有没有解决方法。诚心求解!出错代码为:strSQL="insert into prd_automail_sendmail (mailto,subject,body,sendtime,sendtag) values(\'[email protected]\',\'您有邮件\',\'有张精美贺卡\',\'2005-1-11 14:09:00\',0)";
m_DB.Execute(strSQL);
m_DB.Execute(strSQL);
Provider=MySQLProv;Location=服务器ip;Data Source=数据库名;User Id=xxx;Password=xxxxx;useUnicode=true
http://dev.mysql.com/get/Downloads/Win32/MyOLEDB3.exe/from/http://mysql.ihostunit.com/
Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
conn.ConnectionString = "Provider=MySQLProv;Location=localhost;Data Source=test;User Id=root"
conn.Open
Dim rst As Recordset
Set rst = New ADODB.Recordset
conn.CursorLocation = adUseClient '游标一定设置这种模式
rst.Open "select * from table2 where 1<>1", conn, adOpenKeyset, adLockOptimistic
rst.AddNew
rst.Fields("field2").Value = "测试中文"
rst.Update
conn.Close
Set conn = Nothing
官方驱动的BUG