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
Next Post| Fixing " The server farm account should not be used for other services." SharePoint 2013 Central Administration | Enable session State in SharePoint 2013 |
No comments:
Post a Comment