🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #772

Re: ��δ洢������Ϣ��MySql

#772
From: fwb
Date: Wed, 29 Oct 2008 09:06
26 lines
1971 bytes
��ϸ����鿴
MySQL 5.0 Reference Manual
Chapter 8. Internationalization and Localization
8.1.4. Connection Character Sets and Collations

�򵥵�˵������ʱ���� DEFAULT CHARACTER SET 'charset_name',
client��������ʱ��ҲҪ���� CHARACTER SET 'charset_name',

���֪����ô�ڽ�����ʱ���� CHARACTER SET��
Ҳ�����ڸս�������ʱ������ִ����� SET NAMES 'charset_name'

�� �� zangcp (9Ū2��) �Ĵ������ᵽ: ��
: лл���
: ���ǿɷ�����ϸЩ�أ������������š�����
: �����ʱ����
: create table test (name char(10)) character set gb2312
: ��insert ��ʱ�����ôд�أ�
: �ٴ�лл
: �� �� fwb �Ĵ������ᵽ: ��
: : server�˽���ʱ��Ϊ gb2312��
: : Ȼ��client ����ʱ��set names gb2312��
: : ����Ϳ����ˡ�
: .................������ʡ�ԣ�
--

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 211.99.222.55]
Technical Details
Message-ID: <4cd9T6$aij@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,cda6e063df8cfcaf
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!news.shec6.edu.cn!SJTU
From: fwb.bbs@bbs.sjtu.edu.cn (fwb)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��δ洢������Ϣ��MySql
Date: 29 Oct 2008 09:06:28 GMT
Organization: ��ˮ˼Դ
Message-ID: <4cd9T6$aij@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1225270902.A
Lines: 26