🚀 go-pugleaf

��Һã�
            ���õ���MySql 5.1�İ汾������VCд��һ��ADO������������MySql�������ڲ������ĵ�ʱ�����DZ��?
��������ǣ�
       1064 You have an error in your SQL syntax;
       check the manual that corresponds to your MySQL server version for 
the right syntax to use near '' at line 1

       ��д�IJ��������� Insert into 
T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','������','������');
       ����һ���Ӣ�ľ���ִ�гɹ���Insert into 
T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','aaa','aaa');

       ���ʴ������ʲôԭ���ַ�Ҳ����İ� �Ұ�����Ϊ��
      Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc) 
values('admin',_gbk'������',_gbk'������');
Ҳ���С�

      ����һ�£������������ִ�������䶼��û������ģ������һ��ܲ�ѯ������ 

mysql> show variables like '%char%';
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | gbk                      |
| character_set_connection | gbk                      |
| character_set_database   | gbk                      |
| character_set_filesystem | binary                   |
| character_set_results    | gbk                      |
| character_set_server     | gbk                      |
| character_set_system     | utf8                     |
| character_sets_dir       | D:\MySql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.00 sec)
mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc) 
values('admin',_gb
k'������',_gbk'������');
Query OK, 1 row affected (0.05 sec)
mysql> select * from T_addressGroup;
+------+---------+-------------+--------+
| F_Id | F_Owner | F_GroupName | F_Desc |
+------+---------+-------------+--------+
|    1 | admin   | ������      | ������ |
+------+---------+-------------+--------+
1 row in set (0.00 sec)
mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc) 
values('admin','��
����','������');
Query OK, 1 row affected (0.05 sec)
mysql> select * from T_addressGroup;
+------+---------+-------------+--------+
| F_Id | F_Owner | F_GroupName | F_Desc |
+------+---------+-------------+--------+
|    1 | admin   | ������      | ������ |
|    2 | admin   | ������      | ������ |
+------+---------+-------------+--------+
2 rows in set (0.00 sec)