How can I change the site collection default language in Sharepoint 2007

You install the required language version of WSS 3.0 / MOSS 2007.
The only thing you can do with Language Packs (for instance) is to add a Site template for that Language so that you can either chose the original language of the installation or that additional language for **a site**.
But site collections (and admin messages) are always in the language of the language version of WSS 3.0 / MOSS 2007 which you installed. (But individual sites within them not necessarily)

Thanks alot for reply butin my case i installed language packages then create a site collection in french then the client request from me to change the settings page language to english
I appreciate your reply --

Hello,

You can create multi-language sharepoint sites by using variations. The following link include the detailed information about how to configure multilingual sharepoint sites, you can take reference from it:

MOSS Multilingual Site Configuration:

http://www.codeproject.com/KB/sharepoint/MOSS_multilingual.aspx?display=Print

Regards,

Jerry

Hello,

I'm really sorry to say this, but you can't change the language of an existing site in any way that is supported.
The best thing you can do is to create a new site in the correct language and migrate the data from the old site to the new one.

Really thank you Mirjambecauseyou are the only one which completelyunderstood what i was mean by my post, unfortunatly i know that i can't do it but i tried on technet.
I hope this issue to be solved in the next version of Sharepoint.

for all whom reply to me if you want communicate with me on dasoqi_aa@yahoo.com

Regards,
Anas---

The thing that I am doing, and is notably a hack, is to change the DOM with JavaScript. You get a bit of a flash of the old word but it seems the best we can do for individual sites. It's kind of a pain in the neck, since the default layouts are table-based without a lot of element ids so the WSS HTML is awful, but you can still do a bunch of things with JavaScript to change certain words per site.
Here's an example of changing "Survey" to "Questionnaire". The function_spBodyOnLoadFunctionNamesuses WSS's JavaScript to add it to the onload event. Each for block in the SetPhrasing method is specific to a particular area in a specific page - you'll need to write your own loops to do whatever you need.

<script type="text/javascript" defer="true">		
		
	function SetPhrasing(oldText, newText)
	{
		var x = document.getElementsByTagName("td");
		for (var i=0; i<x.length; i++){
			if (x[i].className == "ms-formlabel"){
				x[i].innerText = x[i].innerText.replace(oldText, newText);			
			}
		}
		
		
		var x = document.getElementsByTagName("div");
		for (var i=0; i<x.length; i++){
			if (x[i].className == "ms-buttoninactivehover"){
				var a = x[i].getElementsByTagName("a")[0];
				a.innerText= a.innerText.replace(oldText, newText);			
			}
		}

		
	}
	
	function SetAllPhrasings(){
		SetPhrasing('Survey','Questionnaire');	
	}

	_spBodyOnLoadFunctionNames.push("SetAllPhrasings");	
	
</script>

Good luck,
Dirk Watkins

OK, It's me again answering my own question(s)...

http://sharepointchick.com/archive/2008/04/29/changing-the-language-of-an-existing-sharepoint-site.aspx

It works so good this sql_way! After searching around for so long time I've finally found this soluion! done in a few seconds!

george

http://stackoverflow.com/questions/3599492/how-can-i-change-a-sites-default-language-after-creation-sharepoint-2010/3609062#3609062