Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Testing Multi-Language Support - NLS

Author  Topic 

Starting Member

2 Posts

Posted - 2004-09-15 : 18:33:35
I've been tasked with testing a client application using SQL Server 2000 and NLS support. I've never done this before so it is confusing to me. I've been asked to make sure that the client application (running on Windows 2000) supports the following languages:

English UK
French (Belgium)
And maybe Korean and Japanese.

The client that I am testing is an Admin tool similiar to Enterprise Manager. Like I stated earlier I've never done this before so I have the following questions:

1. What do I need to do to SQL Server 2000 to setup for such testing? Do I need to install different versions of SQL Server 2000?

2. Do I need to generate data in each language from some tool to input into SQL Server in order to test?

3. I know this is not a Windows forum but do I need to setup anything in the Windows 2000 environment for the various languages?

If any one has done something similiar to this or can shed some light please let me know. Any help that you can provide would be much appreciated.

Thank you.

Almighty SQL Goddess

38200 Posts

Posted - 2004-09-15 : 18:35:25
Does the database schema support multiple languages? Data types would need to be nvarchar and nchar for the character and variable character columns.

Go to Top of Page

Starting Member

2 Posts

Posted - 2004-09-16 : 11:57:33
Yes. The database schema does support multiple languages.
Go to Top of Page

- Advertisement -