collation

From: sysbox27 (sysbox27_at_discussions.microsoft.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 06:33:05 -0800

Hi,
I have built a server based on a db's collation that I want to load, however
I still receive the 'cannot resolve collation conflict for equal to
operation'.

I have checked the collations of the loaded against the tempdb.
loaded db:
SQL_Latin1_General_CP1_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
Data

tempdb:
Latin1_General_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive

I would have thought the above would have been ok?

Does this mean a rebuild of master db to map collation to db?

Thanks.

Relevant Pages

  • 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)
  • 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.server)
  • 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.setup)
  • 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.odbc)