Changing the Language

Question

Post reply

Changing the Language

joshy mathew

Old Hand

Points: 361
More actions
March 27, 2008 at 2:44 am

#121091

hi
How can i change the language of the database

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 1

Ignacio A. Salom Rangel

SSC-Insane

Points: 20443

March 27, 2008 at 5:19 pm

#794947

Could you be more specific?

My blog

joshy mathew Old Hand Points: 361 More actions · Answer 2

what i mean is ,

I have to convert my database to other languages like arabic,french etc

gan-685682 Ten Centuries Points: 1216 More actions · Answer 3

in MSSQL 2000:

1) Right-click on the server instance in Enterprise Manger.

2) Select "Properties"

3) Go to tab "Server Setting", there's a field called "Default language for user"

or you are talking about collation?

ChiragNS One Orange Chip Points: 26137 More actions · Answer 4

Hi

If you want to store the data in a different languages then we are talking about collations. Collations can be set for the whole database and also can be set for the columns in a table. The collation of a database is the default collation of the columns. How ever the collations for a column(s) can be changed to be different from the database collation.

However if the same column needs to store data in different languages then you have to use unicode data types.

Ex:- Employee table - EmployeeName column should store names in different languages then the EmployeeName column should be of Nvarchar datatype.

Check out BOL for details.

"Keep Trying"

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 5

Here are some links:

http://msdn2.microsoft.com/en-us/library/ms144260.aspx

http://msdn2.microsoft.com/en-us/library/ms190920.aspx

Good luck!

My blog