I'd created a database in SQL_Latin1_General_CP1_CI_AS.
Now I want to store data in another language.
Therefore I created a table and the columns are set to
"Chinese_Taiwan_Stroke_CI_AI" Collation.

However, when I insert data to the table,
the records are "???"

Can anyone help me?
Thanks

Try to use Unicode datatypes for strings.
Then you should have no problem with different collations.

--for example:
create table CCC (iid int identity(1,1) not null,
    col1 nchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AI,
    col2 nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AI)

Still not work.

I need to create another database in the chinese_taiwan collation.
Then the field can store chinese words.

Do you have another method?
Thanks a lot!