I am installing 2 new SQL Server 2000 databases (test and production) for
eRoom. In the past, our servers and databases were just set up for English.
Now my company includes China, Japan, Germany, France and USA. I want to
make sure the new database will support all of these languages. The servers
are running MS Windows Server 2003 Standard Edition, Service Pack 1. It
looks like the person that installed Windows on these servers has installed
code page conversion tables that include Japanese, Simplified Chinese,
Traditional Chinese, IBM EBCDIC Germany, IA5 German, US ASCII, among other
languages.
My question is, in order to make my SQL Server database compatible with the
5 languages that my company is using, will the installation of SQL Server
automatically pick up all of the languages that are installed on the server,
or is there something I need to do to SQL Server to set the collation? I
will be importing the data from our current databases that are set up as
English and SQL_Latin1_General_CP1_CI_AS. Also, on the Advanced Tab of
Regional and Language Options on the server, do I need to check the box for
Current User Account and Default User Profile, in order to pick up all of the
Code Page Conversion Tables. Thank you for your .

Randy

Randy,

SQL Server has one default collation. However, you can use unicode data
types for your columns. Check in Books OnLine nchar, nvarchar and ntext data
types is this is what you need.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

"RandyS" <RandyS@discussions.microsoft.com> wrote in message
news:CFFE120F-9D20-479A-8E2F-A87686984DB0@microsoft.com...
>I am installing 2 new SQL Server 2000 databases (test and production) for
> eRoom. In the past, our servers and databases were just set up for
> English.
> Now my company includes China, Japan, Germany, France and USA. I want to
> make sure the new database will support all of these languages. The
> servers
> are running MS Windows Server 2003 Standard Edition, Service Pack 1. It
> looks like the person that installed Windows on these servers has
> installed
> code page conversion tables that include Japanese, Simplified Chinese,
> Traditional Chinese, IBM EBCDIC Germany, IA5 German, US ASCII, among other
> languages.
> My question is, in order to make my SQL Server database compatible with
> the
> 5 languages that my company is using, will the installation of SQL Server
> automatically pick up all of the languages that are installed on the
> server,
> or is there something I need to do to SQL Server to set the collation? I
> will be importing the data from our current databases that are set up as
> English and SQL_Latin1_General_CP1_CI_AS. Also, on the Advanced Tab of
> Regional and Language Options on the server, do I need to check the box
> for
> Current User Account and Default User Profile, in order to pick up all of
> the
> Code Page Conversion Tables. Thank you for your .
>
> Randy