Friday, March 23, 2012

how to change in SQL 2005 and accept the bin caracter and the langage

Hello

I am newbies with SQL 2005 Sad

I want install Windows sharepoint services 3 in french on my SBS 2003 R2 SP2 also in frecnh langage and at the end of the install, a message say to me :

Bin caracter are not accepted in your configuration SQL

Langage is not correct (I have French_CS_AS)

Where is possible to change these parameters ?

I try to find but never find Sad

Thank You in advance for your help

++

Michel

If you have the answer in French it's better for me but not neccessary !

You need to change your collation to French_BIN which means alter database and change collation you can do it in the database properties. You have to know that BIN(binary collation) is the fastest sort but it also require you to use case sensitive data including queries. Run a search for ALTER database, table and columns and binary sort in SQL Server BOL. Check out SQL Server collations below.

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

No comments:

Post a Comment