Change the language of a website in Sharepoint 2007?

Question

I have been working in my development machine with a Sharepoint installed in English. So the website I created and am woking on appears in English, I have created variations in different languages too (Spanish, Catalan, Basque, Galician). Now I realise that the admin part that is in English, should be in Spanish.

I don't know how I could change the language, i have seen the following answer in a forum:

UPDATE dbo.Webs SET Language = 3082

This solves the problem for the language, the admin part of the website appears in Spanish, but when I enter the section of variation labels, it gives me an error.

Can anyone tell me the solution, or which other column in which table must I change (I know it is not recommended)?

Which is the table where it is saved the info about variations?

Answer 1

Please have a look at our multilingual solution for MOSS http://www.alphamosaik.com/Pages/Solutions_EN_MultilingualModule.aspx

Regards

Alphamosaik

Answer 2

An update with no where clause - you may have just set all your variations to use the same language.

You'll also have the issue that keys get created in English, and after you make the change it searches for the keys in Spanish.

Answer 3

You should be very careful with modifying the database... not only is it not recommended but it will make your SharePoint environment unsupportable by Microsoft. Good for laughs, not much else.

So to give you the official answer, you cannot do what you are attempting without recreating the website. To quote Deploy language packs (Office SharePoint Server):

...once you choose a language-specific site template for a site or a site collection, the site or site collection will always display content in the language of the original site template.