chinese data

please can you tell how you managing database for chinese

do we need to specify collation even if we use utf-8

how to use utf-8

thanks in advance

You should keep the data types as nvarchar
and while inserting the row in the database through query use the character N

e.g.

INSERT INTO TABLE_NAME (FIELD_1, FIELD_2) VALUES (N'VALUE 1' , N'VALUE 2')\

the character N and then the value in the single quotes if text

regards

|||

thanks i need small infoon whether we need to specify collation type

|||

Hi,

Right. You may set collations at the Server, Database, Column or Expression level of a SQL Server 2005 instance. For the collation name, you may refer the following link.

http://msdn2.microsoft.com/en-us/library/ms143508.aspx

Thanks.