Collation of Database and Server

From: Marcus Schmidt (Schmidt_Marcus*at*gmx.de)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 11:09:49 +0100

Hello,

I am working a problem according to the collation of MS SQL Server
2000 and a database.

Environment: German MS SQL Server 2000 SP3a
Server Collation: Latin1_General_CI_AS

Collation of the database: SQL_Latin1_General_CP1_CI_AS
(Note: the database was created in an english MSDE and dureing an
upgrade restored on the SQL Server)

During an application upgrade process (refering to the SQL Server
database) I was running into a lot of problems according the datetime
format. So my suggestion was that this problem is related to the
different collations, cause in a different testing environment with
another collation (server collation = database collation) I was able
to perform the upgrade.

So, now I am wondering if itīs possible to change the database
collation without loosing my data? (hoping that this will solve the
prolem)

Any suggestions or experiences are welcome

tia,
Marcus

Relevant Pages

  • Turkish character problem in SQL Server 2000
    ... I'm trying to migrate a Sybase SQL Anywhere database to SQL server 2000. ... have a problem when I choose "Turkish_CI_AS" as the database collation: ... When I use lowercase Ithere's no error. ...
    (microsoft.public.sqlserver.programming)
  • Collation of Database and Server
    ... I am working a problem according to the collation of MS SQL Server ... 2000 and a database. ... Environment: German MS SQL Server 2000 SP3a ...
    (microsoft.public.sqlserver.server)
  • Re: curious problem in production
    ... >> trying to insert into the same sql server database. ... >> if it fails in calling the production environment. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: curious problem in production
    ... >> trying to insert into the same sql server database. ... >> if it fails in calling the production environment. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database collation error after moving to a remote sql server
    ... > I've recently my SMS 2003 database to a remote sql server (it was ... > Server]Cannot resolve collation conflict for equal to operation. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)