sql2k Collation problems.

From: "Adrian Parker" <apparker@xxxxxxxxxxxxx>
Date: Wed, 7 Dec 2005 15:47:03 -0000

We've found a problem when the instance of SQL server was created with a
collation of Latin1_General_CI_AS and a database is attached that has a
collation of SQL_Latin1_General_CP1_CI_AS.

The problem is that if you create a table in that database, it takes the
collation of the database, but if you create a function, it takes its
collation from the server instance, so using that function in a where clause
causes problems.

Is there any way of changing the collation of an existing server instance or
do we have to get them to re-install sqlserver ?

Thanks

Adrian Parker
Ingenuity At Work Ltd

.

Follow-Ups:
- RE: sql2k Collation problems.
  - From: Sophie Guo [MSFT]

Prev by Date: Re: Can not uninstall
Next by Date: Re: Missing Local SQL Server in "Manage" MMC.... how to restore?
Previous by thread: Re: Can not uninstall
Next by thread: RE: sql2k Collation problems.
Index(es):
- Date
- Thread

Relevant Pages

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)
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)
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)