Recently, I had a problem with one of my SharePoint team site. The problem was that the site’s created in English, however; we need it in Persian. Adding Persian as an Alternate language could be a good solution but we need the site just in Persian.

I tried to change it programmatically but it didn’t work since the Language property of SPWeb object is read-only! The only way I found and worked very well was updating language field in the Database.


  1. Open up AllWebs table in the correct Database
  2. Find the desired site and change the value of Language Field
    The language code for English is “1033” and for Persian is “1065”

You could also do it by executing an update query if you know the SiteCollectionId:
       Update dbo.AllWebs set Language=”1065″ Where SiteId=”SiteCollectionId”


  • Directly modifying the Database will invalidate Microsoft’s support.
(Visited 1,030 times, 1 visits today)

About the author 

Sarah Safari

Summit Bundle

Get 200+ hours of Microsoft 365 Training for 7$!

Master Office 365, Power Platform & SharePoint & Teams With 200+ Hours Of Training Videos in the Collab365 Academy. This offer is insane and is only available for a limited period.