Changing the language of an existing SharePoint site

For changing the language of all sites in the content database to Chinese the query would be: UPDATE dbo.Webs SET Language = 2052 Changing the language of one site collection can be done with: UPDATE dbo.Webs SET Language = 2052 WHERE SiteId = [[SiteCollectionId]] And for changing the language of a single web or subsite you can use: UPDATE dbo.Webs SET Language = 2052 WHERE Id = [[WebId]]