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?

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?