Changing the language of an existing SharePoint site

 Changing the language of an existing SharePoint site.

UPDATE dbo.Webs SET Language = 1033 where Title='System'

Changing the language of one site collection can be done with:

UPDATE dbo.Webs SET Language = 1033 WHERE SiteId = [[SiteCollectionId]]

And for changing the language of a single web or subsite you can use:

UPDATE dbo.Webs SET Language = 1033 WHERE Id = [[WebId]]

     Following are language and ID.          

Language	Language ID
Arabic	1025
Azeri (Latin)	1068
Basque (Basque)	1069
Bosnian (Latin)	5146
Bulgarian	1026
Catalan	1027
Chinese (Simplified)	2052
Chinese (Traditional)	1028
Croatian	1050
Czech	1029
Danish	1030
Dari	1164
Dutch	1043
English	1033
Estonian	1061
Finnish	1035
French	1036
Galician	1110
German	1031
Greek	1032
Hebrew	1037
Hindi	1081
Hungarian	1038
Indonesian	1057
Irish	2108
Italian	1040
Japanese	1041
Kazakh	1087
Korean	1042
Latvian	1062
Lithuanian	1063
Macedonian	1071
Malay (Malaysia)	1086
Norwegian (Bokmål)	1044
Polish	1045
Portuguese (Brazil)	1046
Portuguese (Portugal)	2070
Romanian	1048
Russian	1049
Serbian (Cyrillic)	3098
Serbian (Latin)	2074
Slovak	1051
Slovenian	1060
Spanish	3082
Swedish	1053
Thai	1054
Turkish	1055
Ukrainian	1058
Vietnamese	1066
Welsh	1106

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

Fixing " The server farm account should not be used for other services." SharePoint 2013 Central Administration

Enable session State in SharePoint 2013