x

How to add a language to SQL Server 2008 R2

Hi,

I have been trying to add a language to SQL, but I am having no luck. I tried using sp_addlanguage, but it says that it is not found. I have read that it was deprecated, so now I am confused.

Is the following no longer available?

exec sp_addlanguage french, null, 'janvier,fevrier,mars,avril,mai,juin,juillet, aout,septembre,octobre,novembre,decembre', 'jan,fev,mars,avr,mai,juin,jui,aout,sept,oct, nov,dec', 'lundi,mardi,mercredi,jeudi,vendredi,samedi, dimanche', dmy, 1

How do I add a language to SQL?

Regards, Pierre

more ▼

asked Dec 16, 2011 at 03:11 AM in Default

avatar image

Skaap
12 2 2 3

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

In general you're going to be able to control the language during a localized install of the product and for full text indexing. Other than that, I'd suggest reading through this section of the Books Online to understand what you can do with multiple languages on the system.

more ▼

answered Dec 16, 2011 at 03:27 AM

avatar image

Grant Fritchey ♦♦
137k 20 42 81

(comments are locked)
10|1200 characters needed characters left

I want to use: SET LANGUAGE Ukrainian SELECT DATENAME(month, @Today) AS 'Month Name'

Ukrainian does not exist, so I would like to add it using sp_addlanguage, but that does not exist anymore, so how do I add the language?

more ▼

answered Dec 16, 2011 at 03:35 AM

avatar image

Skaap
12 2 2 3

It's my understanding that language support in SQL Server derives from the underlying operating system (except for the localized install and full text support). I'd start there. Again, the BOL section I sent you to will help.

Dec 16, 2011 at 03:38 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x985
x6

asked: Dec 16, 2011 at 03:11 AM

Seen: 6748 times

Last Updated: Dec 16, 2011 at 03:11 AM

Copyright 2016 Redgate Software. Privacy Policy