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.
