- Katılım
- 26 May 2008
- Mesajlar
- 157
- Reaction score
- 1
- Puanları
- 0
- Konum
- Bellirli Degil
- Web sitesi
- www.ko-cuce.com
1394 clint sohunun son clint sanırım denemekte fayda war
http: / / download.17173.com/82/10/11892/
SQL2008汉化库表的方法:工具-》选项-》下图-》把表设计器选项里的阻止保存要求重新创建表的更改前面的勾去掉;然后再选择表鼠标右键设计表-》选择列名-》修改排序规则为Chinese_PRC_CS_AS-》保存表。就可以写入中文啦。也希望楼主把所遇问题和解决问题的办法贴出来与论坛里的朋友一起共享,这才是骑士爱好者论坛的目的。
http: / /i3.6.cn/cvbnm/1f/2b/6f/546b18a9af3d92afafeebd2db2483c1a.jpg
http: / /i3.6.cn/cvbnm/80/05/d3/f4554c391fde3a780533b83cb2b86895.jpg
http : / /i3.6.cn/cvbnm/52/12/0d/bd5cc92949294eeea30cfd5fbe13d40c.jpg
REATE TABLE [USERDATA] (
[strUserId] [varchar] (23) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NOT NULL ,
[Nation] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Nation] DEFAULT (0),
[Race] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Race] DEFAULT (1),
[Class] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Class] DEFAULT (0),
[HairColor] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Gender] DEFAULT (0),
[Rank] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Rank] DEFAULT (0),
[Title] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Title] DEFAULT (0),
[Level] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Level] DEFAULT (1),
[Exp] [int] NOT NULL CONSTRAINT [DF_USERDATA_Exp] DEFAULT (1),
[Loyalty] [int] NOT NULL CONSTRAINT [DF_USERDATA_Loyalty] DEFAULT (50),
[Face] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Religion] DEFAULT (0),
[City] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_City] DEFAULT (0),
[Knights] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Knights] DEFAULT (0),
[Fame] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Fame] DEFAULT (0),
[Hp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Hp] DEFAULT (100),
[Mp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Mp] DEFAULT (100),
[Sp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Sp] DEFAULT (100),
[Strong] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Str] DEFAULT (0),
[Sta] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Sta] DEFAULT (0),
[Dex] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Dex] DEFAULT (0),
[Intel] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Intel] DEFAULT (0),
[Cha] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Cha] DEFAULT (0),
[Authority] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Authority] DEFAULT (1),
[Points] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Points] DEFAULT (0),
[Gold] [int] NOT NULL CONSTRAINT [DF_USERDATA_Gold] DEFAULT (0),
[Zone] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Zone] DEFAULT (1),
[Bind] [smallint] NULL ,
[PX] [int] NOT NULL CONSTRAINT [DF_USERDATA_PX] DEFAULT (268100),
[PZ] [int] NOT NULL CONSTRAINT [DF_USERDATA_PZ] DEFAULT (131000),
[PY] [int] NOT NULL CONSTRAINT [DF_USERDATA_PY] DEFAULT (0),
[dwTime] [int] NOT NULL CONSTRAINT [DF_USERDATA_dwTime] DEFAULT (0),
[strSkill] [varchar] (10) COLLATE Chinese_PRC_Stroke_CI_AS NULL CONSTRAINT [DF_USERDATA_strSkill] DEFAULT (0x00),
[strItem] [varchar] (400) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[strSerial] [varchar] (400) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[sQuestCount] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_sQuestCount_1] DEFAULT (0),
[strQuest] [varchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[MannerPoint] [int] NOT NULL CONSTRAINT [DF_USERDATA_MannerPoint] DEFAULT (500),
[LoyaltyMonthly] [int] NOT NULL CONSTRAINT [DF_USERDATA_LoyaltyMonthly] DEFAULT (0),
[CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_USERDATA_CreateTime_1] DEFAULT (getdate()),
[UpdateTime] [smalldatetime] NULL ,
[d_id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_USERDATA] PRIMARY KEY CLUSTERED
(
[strUserId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
konun orj link
http : / /www . knightonline.cn/bbs/thread-11697-1-1.html
http: / / download.17173.com/82/10/11892/
SQL2008汉化库表的方法:工具-》选项-》下图-》把表设计器选项里的阻止保存要求重新创建表的更改前面的勾去掉;然后再选择表鼠标右键设计表-》选择列名-》修改排序规则为Chinese_PRC_CS_AS-》保存表。就可以写入中文啦。也希望楼主把所遇问题和解决问题的办法贴出来与论坛里的朋友一起共享,这才是骑士爱好者论坛的目的。
http: / /i3.6.cn/cvbnm/1f/2b/6f/546b18a9af3d92afafeebd2db2483c1a.jpg
http: / /i3.6.cn/cvbnm/80/05/d3/f4554c391fde3a780533b83cb2b86895.jpg
http : / /i3.6.cn/cvbnm/52/12/0d/bd5cc92949294eeea30cfd5fbe13d40c.jpg
REATE TABLE [USERDATA] (
[strUserId] [varchar] (23) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NOT NULL ,
[Nation] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Nation] DEFAULT (0),
[Race] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Race] DEFAULT (1),
[Class] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Class] DEFAULT (0),
[HairColor] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Gender] DEFAULT (0),
[Rank] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Rank] DEFAULT (0),
[Title] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Title] DEFAULT (0),
[Level] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Level] DEFAULT (1),
[Exp] [int] NOT NULL CONSTRAINT [DF_USERDATA_Exp] DEFAULT (1),
[Loyalty] [int] NOT NULL CONSTRAINT [DF_USERDATA_Loyalty] DEFAULT (50),
[Face] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Religion] DEFAULT (0),
[City] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_City] DEFAULT (0),
[Knights] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Knights] DEFAULT (0),
[Fame] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Fame] DEFAULT (0),
[Hp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Hp] DEFAULT (100),
[Mp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Mp] DEFAULT (100),
[Sp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Sp] DEFAULT (100),
[Strong] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Str] DEFAULT (0),
[Sta] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Sta] DEFAULT (0),
[Dex] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Dex] DEFAULT (0),
[Intel] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Intel] DEFAULT (0),
[Cha] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Cha] DEFAULT (0),
[Authority] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Authority] DEFAULT (1),
[Points] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Points] DEFAULT (0),
[Gold] [int] NOT NULL CONSTRAINT [DF_USERDATA_Gold] DEFAULT (0),
[Zone] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Zone] DEFAULT (1),
[Bind] [smallint] NULL ,
[PX] [int] NOT NULL CONSTRAINT [DF_USERDATA_PX] DEFAULT (268100),
[PZ] [int] NOT NULL CONSTRAINT [DF_USERDATA_PZ] DEFAULT (131000),
[PY] [int] NOT NULL CONSTRAINT [DF_USERDATA_PY] DEFAULT (0),
[dwTime] [int] NOT NULL CONSTRAINT [DF_USERDATA_dwTime] DEFAULT (0),
[strSkill] [varchar] (10) COLLATE Chinese_PRC_Stroke_CI_AS NULL CONSTRAINT [DF_USERDATA_strSkill] DEFAULT (0x00),
[strItem] [varchar] (400) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[strSerial] [varchar] (400) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[sQuestCount] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_sQuestCount_1] DEFAULT (0),
[strQuest] [varchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[MannerPoint] [int] NOT NULL CONSTRAINT [DF_USERDATA_MannerPoint] DEFAULT (500),
[LoyaltyMonthly] [int] NOT NULL CONSTRAINT [DF_USERDATA_LoyaltyMonthly] DEFAULT (0),
[CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_USERDATA_CreateTime_1] DEFAULT (getdate()),
[UpdateTime] [smalldatetime] NULL ,
[d_id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_USERDATA] PRIMARY KEY CLUSTERED
(
[strUserId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
konun orj link
http : / /www . knightonline.cn/bbs/thread-11697-1-1.html
