RE: collation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sasan Saidi (SasanSaidi_at_discussions.microsoft.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 08:35:12 -0800

Hi sysbox27,

Definitly not the same! You can:
1. Rebuild you master database to have the same collation as your user
database.
OR
1.Change your user database collation to match the server collation by A)
Using DTS or Alter database, Alter table/alter column (the Alter table/alter
column has many restrictions). The following article describes how the above
can be done:

Article title: How to transfer a database from one collation to another
collation in SQL Server
Article Link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k

Sasan Saidi
Senior DBA

"sysbox27" wrote:

> 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: Change field collation
    ... constraints and statistics on the columns before you can alter ... There are quite a lot of caveats and you use this script at your own risk. ... Changing the collation of the existing tables is unfortunately not very ... You might consider using SEM to script out the objects in the database, ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing collation -- URGENT
    ... You can use the following script to change the collations of your columns, ... duplicate primary key constraints create statements, ... Changing the collation of the existing tables is unfortunately not very ... You might consider using SEM to script out the objects in the database, ...
    (microsoft.public.sqlserver.server)
  • Re: Database collation error after moving to a remote sql server
    ... I think I'm going to try plan B: Install a second instance of SQL 2000 onto ... the remote server and set its default collation to the same as my SMS ... database, then move my db to the new instance. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)
  • Re: [Info-Ingres] Select, escaping special chars
    ... Yes you can't change the database collation except by re-creating the database. ... [Info-Ingres] Select, escaping special chars ... Executing. ...
    (comp.databases.ingres)
  • Re: COLLATION PROBLEM CAN ANY ONE HELP
    ... Sounds like you may have code page X data in a code page Y database. ... database with a collation that matches the data's actual code page: ... COLLATION PROBLEM CAN ANY ONE HELP ... | Content-Type: text/plain; ...
    (microsoft.public.sqlserver.datamining)