Moving Servers, Matching Collation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David Morgan (REMOVE_david_at_davidmorgan.me.uk)
Date: 04/04/04 

Date: Sun, 4 Apr 2004 17:00:58 +0100

Hi

We are moving our database from a SQL 2K installation on W2K to a SQL 2K on
Windows 2003 machine.

We have a problem with some of the queries where the collation is not
matched. We are using rebuildm.exe to try and change the collation but
cannot seem to find an available collation that matches our old server.

The old server's collation is: SQL_Latin1_General_CP1_CI_AS.

We have tried several of the available collations within rebuildm and Latin1
case insensitive from the first selection options, but we just cannot find a
match and therefore, get our queries to run.

The closest so far is Latin1_General_CI_AS.

Can anyone help me identify which collation in the rebuildm utility, (or
elsewhere), can be used to get our new server to reflect the same collation
as our old server.

Thanks in advance

David M

Relevant Pages

  • Moving Servers, Matching Collation
    ... We have a problem with some of the queries where the collation is not ... cannot seem to find an available collation that matches our old server. ... Can anyone help me identify which collation in the rebuildm utility, ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving Servers, Matching Collation
    ... > We have a problem with some of the queries where the collation is not ... > cannot seem to find an available collation that matches our old server. ... get our queries to run. ... > Can anyone help me identify which collation in the rebuildm utility, ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving Servers, Matching Collation
    ... > We have a problem with some of the queries where the collation is not ... > cannot seem to find an available collation that matches our old server. ... get our queries to run. ... > Can anyone help me identify which collation in the rebuildm utility, ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I change the default collation string of an installation
    ... different collation name in order to be able to accept the character set ... the DTSs successfully copy the Hebrew letters when I copy data with OSQL ... refers to specific databases and uses the destination database's ... OSQL refers to the remote server and destination server ...
    (comp.databases.ms-sqlserver)
  • Re: Different Collation designator Settings
    ... You can have databases with different collations on SQL ... That wasn't possible on SQL Server 7. ... values in temporary tables while assuming that tempdb has the same collation ...
    (microsoft.public.sqlserver.connect)