PHWinfo - Afficher un message - Ensuring sql 2005 server is setup to use Unicode character enc (UT

04/10/2007, 07h30

Hmm I have to say answer is in Collation, but I am not sure. In SQL 2005,
long as you use 'N' front of any string it is treated as UNICODE.

Example:

Insert Into Table1 (A,B,C) Values (N'A', N'C', N'D');

All values for A,B,C are considered unicode. In addition the field types
must be defined as such that is nvarchar, and nchar.

Thanks!

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

"Jeff C." wrote:

> I'm installing a software that requires that I ensure that my database server
> is set up to use Unicode character encoding (such as UTF-8). How can I ensure
> this during installation of MS SQL 2005 server?

04/10/2007, 07h30	#2
Mohit K. Gupta Messages: n/a Hébergeur:	RE: Ensuring SQL 2005 server is setup to use Unicode character enc (UT Hmm I have to say answer is in Collation, but I am not sure. In SQL 2005, long as you use 'N' front of any string it is treated as UNICODE. Example: Insert Into Table1 (A,B,C) Values (N'A', N'C', N'D'); All values for A,B,C are considered unicode. In addition the field types must be defined as such that is nvarchar, and nchar. Thanks! -- Mohit K. Gupta B.Sc. CS, Minor Japanese MCTS: SQL Server 2005 "Jeff C." wrote: > I'm installing a software that requires that I ensure that my database server > is set up to use Unicode character encoding (such as UTF-8). How can I ensure > this during installation of MS SQL 2005 server?