Collation of Database and Server
From: Marcus Schmidt (Schmidt_Marcus*at*gmx.de)
Date: 11/12/04
- Next message: kirtas: "Wildcard * im MS Sql server"
- Previous message: mss: "Re: Client Version ermitteln"
- Next in thread: Frank Kalis: "RE: Collation of Database and Server"
- Reply: Frank Kalis: "RE: Collation of Database and Server"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: kirtas: "Wildcard * im MS Sql server"
- Previous message: mss: "Re: Client Version ermitteln"
- Next in thread: Frank Kalis: "RE: Collation of Database and Server"
- Reply: Frank Kalis: "RE: Collation of Database and Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
