🚀 go-pugleaf

ò��ÿ�����ӵ��ַ���Ҫ��������
"yong" <cyberblue.yong@gmail.com> д����Ϣ����:eofimp$pj7$1@news.yaako.com...
> �����������
>
> 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)
>>
>>