Dear all:

I create a database with collation name='Chinese_Taiwan_Stroke_CI_AS'. and
then I create a table with collation name='Chinese_PRC_Stroke_CI_AI ' by
using the following code.

CREATE TABLE [dbo].[article_choice_sc] (
[article_id] [int] NOT NULL ,
[issue_date] [smalldatetime] NULL ,
[issue_no] [int] NULL ,
[section_name] [nvarchar] (100) COLLATE Chinese_PRC_Stroke_CI_AI NULL ,
[filename] [nvarchar] (100) COLLATE Chinese_PRC_Stroke_CI_AI NULL
) ON [PRIMARY]

when I insert 'Simplified chinese' to the table,I see messy code in
[section_name] & [filename].

Question:How to solve this problem?

ä½*有è¨*nvarchar的話
應該就å�¯ä»¥å*˜unicode
在enterprice manager應該å�¯ä»¥æ*£å¸¸é¡¯ç¤º
charset的�題 程�端與資料庫端�需考慮

David

Dear David:
I have set nvarchar.Would you tell me what I should do in programme & SQL
Server.Thanks for your help.

"David" wrote:

[myTable]
id(int)
myName(NVarchar)

try it:
INSERT INTO myTable (id, myName)
VALUES (100, N'时间和è¯*言设置居然这么é‡�è¦�')

直接在SQL Server Enterprise Manager裡�看
å�¯é¡¯ç¤ºç°¡é«”å*—
記得è¦�在欲insert的變數å‰�é�¢åŠ*上這個N

David