Unicode ID

[cog]

I am trying to restore a database from my system which has the default unicode locale set to British onto another system that is also set to british. When i type select @@language on both machines it states that the databases are both british. However when i try to restore my database on the other machine it states that the Unicode Id is different and as a result wont restore the database. I have checked using exec sp_configure and on my machine the unicode Id is 1033 and on the other machine it is 2057. Yet on both everything is set to british how do i fix this.

I need to restore my database on the other machine any help would be most appreciated

 

[RickCole]

Bad news I'm afraid.

Unicode 1033 = General
Unicode 2057 = UK English.

The Unicode setting is not the same thing as @@language.

The Unicode option is selected when SQL Server is initially set up and once in place can not be changed dynamically. As it stands to get your database across you could use DTS.

The only other way is with a master database rebuild or a re-install of SQL server to sync up your Unicode selection.

Sorry I couldn't be of more assistance.

Rick.

 

[cog]

Hi

Thanks for your response.

When i re-installed sql server i did not get any option to select the unicode or to configure it to british

 

[RickCole]

Try removing SQL Server and then run a fresh install.

From memory your Unicode selection option is on the screen where you also choose your character set and sort order.

Rick.