RE: sql2k Collation problems.

Hello,

Based on my knowledge, parameters for function is assigned the default
collation of the database:

Specifying Collations
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da_3zw3.asp

*Parameters for stored procedures or functions, user-defined data types,
and variables are assigned the default collation of the database*

However, you can refer to the following information:

1.

Changing Collations
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da_819v.asp

*****************
After a collation has been assigned to any object other than a column or
database, you cannot change the collation except by dropping and
re-creating the object. This can be a complex operation.

To change the default collation for an instance of Microsoft SQL Server
2000 you must:

" Make sure you have all of the information or scripts needed to re-create
your user databases and all of the objects in them.

" Export all of your data using a tool such as bulk copy.


" Drop all of the user databases.


" Rebuild the master database specifying the new collation.


" Create all of the databases and all of the objects in them.


" Import all of your data.


Note: Instead of changing the default collation of an instance of SQL
Server 2000, you can specify a default collation for each new database you
create.

*****************


2. Change the collation of the master database:

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

You can refer to the "Change the collation of the master database" and
"Change the collation of the master database in SQL Server 2000" section.

3.

COLLATE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da_819v.asp

*Creating or altering a database.
You can use the COLLATE clause of the CREATE DATABASE or ALTER DATABASE
statement to specify the default collation of the database. You can also
specify a collation when you create a database using SQL Server Enterprise
Manager. If you do not specify a collation, the database is assigned the
default collation of the SQL Server instance.*

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

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)
  • 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'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)
  • Re: Different collations in a database
    ... The SQL Server itself is correctly setup to use Finnish_Swedish_CI_AS, ... the fields back to database default. ... database with the correct collation. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)