Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a site with 2 language variations: DE, EN. German is set as the standard language.

A number of Chinese users are being added. Their browsers are just set up for Chinese with no other language in the list. This is normal for all foreign installations - just the national language.

Is there a way to change the standard language? Not sure if this is the best approach but it seems to be the easiest solution as the majority of foreign users will prefer English to German.

share|improve this question
    
When I use UPDATE dbo.Webs SET Language = 1043 WHERE SiteId = [[SiteCollectionId]] using the GUID LIKE UPDATE dbo.Webs SET Language = 1043 WHERE SiteId = [GUID] it gives me error, > Msg 207, Level 16, State 1, Line 3 Invalid column name > '75e111c8-9891-5697-8adc-c07f8a9ba10d'. if use UPDATE dbo.Webs SET Language = 1043 WHERE SiteId = '75e111c8-9891-5697-8adc-c07f8a9ba10d' no rows are effected what is right format? Thanks! –  whataname Feb 6 '13 at 12:48

4 Answers 4

this javascript code set language to persian forever. put this code in masterpage.

function setLanguageToPersian(){
if(_spPageContextInfo.currentLanguage != 1065) OnSelectionChange(1065);
}
_spBodyOnLoadFunctionNames.push("setLanguageToPersian");
share|improve this answer

One way to do this without accessing the database is to use site templates (or probably even export/import).
It's not very pretty, but the theory is simple and it have worked for me:

  • Save site as template
  • Find, download and extract the WSP (it's a CAB file).
  • Create missing resource files, find and replace all current language ids (like 1033) with the one you want (such as 1043).
  • Repack the WSP (still as CAB).
  • Upload the WSP.

I see many issues with this approach, such as sites with publishing feature enabled (save site as template disabled) and the extensive amount of work. But at least its an option, and it might be scriptable.

share|improve this answer

For changing the language of all sites in the content database to Dutch the query would be: UPDATE dbo.Webs SET Language = 1043

Changing the language of one site collection can be done with: UPDATE dbo.Webs SET Language = 1043 WHERE SiteId = [[SiteCollectionId]]

And for changing the language of a single web or subsite you can use: UPDATE dbo.Webs SET Language = 1043 WHERE Id = [[WebId]]

share|improve this answer

I did it last week using this article:

Mirjam's thoughts on SharePoint: Changing the language of an existing SharePoint site

share|improve this answer
4  
From the comments on that article: "Interesting, but the only problem here is that modifying directly the DB will invalidate Microsoft's support." –  Stuart Pegg Feb 28 '12 at 7:53
    
Yes that's the problem... –  Seb Feb 28 '12 at 8:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.