Share via

How to Change the language of Existing Sharepoint site using SQL queries in background

  • Article

Here I am trying to explain how to change the language of Existing sharepoint site using SQL Query
Note: Before converting sharepoint site language don't forget to install the required language packs.. please refer below links to know about sharepoint language pack installation
Note: Take Granular backup of site before start the procedure

Sharepoint 2013 language pack install/uninstall
Sharepoint 2016 language pack install/uninstall

Procedure:
Before start get the name of sharepoint content database where your site/site-collection[which you are plaing to change language] resides.. refer below microsoft article for how to know the content database

How to get content database name

  1. open SQL server Management Studio

  2. Run below query to select the content database which you get from above query 

USE <Content DB Name> /*Content DB Name  where your site resides */
  1. Execute the below query to get the list of all sites in content database
SELECT * FROM DBO.WEBS /*This query will return you list with ID,SiteID,URL,Title,Languageid */

  1. Note the ID of your site whose language your planning to change[Can identify by Title and URL]

  2. Execute the below quarries to change the language to English
    Note: Before Executing, note the languageID and localeID of language to which you want to change[Eg:1033,1033]
    refer below link to get languageID and localeID

Sharepoint Languageid and localeID

UPDATE dbo.Webs SET Language = 1033, Locale = 1033
WHERE Id = 'A0A1325C-8B8C-4B27-A3AE-D156CEFBB865'  /*Here 1033 is English languageID and localeID, HERE ID you will get from executing step 3 */
  1. Execute the below quarries to change the language to Arabic
    Note: Before Executing, note the languageID and localeID of language to which you want to change[Eg:1025,14337 ]
UPDATE dbo.Webs SET Language = 1025, Locale = 14337
WHERE Id = 'A0A1325C-8B8C-4B27-A3AE-D156CEFBB865'  /*Here 1025,14337 is Arabic languageID and localeID, HERE ID you will get from executing step 3 */