Re: ��һ��ݿ⺺�ֲ�ѯ��

Article View: cn.bbs.comp.database

Article #138

Back to cn.bbs.comp.database Previous Next

#138

From: �F��ħ��ɳ
Date: Wed, 15 Sep 2010 16:53

22 lines
2213 bytes

SSMS��ѯû������Ļ�˵�����ⲻ����ݿ����
���ư˳��Ǵ���ҳ��ȡ��ʱ�������⡣
��û�Ǵ�Ļ���SSMS��Ӧ�ö���UTF-16����
�� �� paopoa (����) �Ĵ������ᵽ: ��
: ���ʱ������վ����ҳʱUTF-8����
: �õ���MSSQLSERVER 2005��ݿ�
: �ڱ�д����ҳ���ʱ�򣬷������к�������֮���޷�����ݿ�õ���Ϣ
: ���ֺ�Ӣ���ַ��ǿ��Ե�
: ֱ������ҵ����������ݿ⣬��ѯ���ַ���ʱ���Է�����ݵ�
: �һ����Ǳ�����ʲô�ط�û���
: ��ݿ��collation �� Chinese_PRC_CI_AS
: ����˵��ѯ��ʱ��д������" like N'%xxxxxx%' COLLATE Chinese_PRC_CI_AS"
: �����»���û�����
: ��ȫ�����ˣ���֪������������
: .................������ʡ�ԣ�

--
��ͨ���\ħ����Ů����ɫ�ޥ����`���ѩ`��
����ޥ����`���ѩ`���� ħ�h���ե����ʥ륹�ѩ`����
ħ��ɳ ��������˽? �������ʡ�������Ρ���Ů������

[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.22.80.149][m

Technical Details

Message-ID: <51lIfW$bmW@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!news.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,4d8b0810e40fc652,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid4df683fd51,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!news.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: Marisa.bbs@bbs.sjtu.edu.cn (�F��ħ��ɳ)
Newsgroups: cn.bbs.comp.database
Subject: Re: ���һ��������ݿ⺺�ֲ�ѯ������
Date: 15 Sep 2010 16:53:59 GMT
Organization: ��ˮ˼Դ
Message-ID: <51lIfW$bmW@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1284569552.A

Article View: cn.bbs.comp.database

Re: ���һ��������ݿ⺺�ֲ�ѯ������

Re: ��һ��ݿ⺺�ֲ�ѯ��