🚀 go-pugleaf

�����������

check the manual that corresponds to your MySQL server version for
the right syntax to use near '' at line 1

д����˫��ţ�"���ĵط����Ĵ��������³��򣬿�����û�мӴ��˫��š�

xiaotiger666@hotmail.com wrote:
> ��Һã�
>             ���õ���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) 
> 
>