table default collation

[rsx]

Hello,

When I a run a script to create tables (SQL Server 2000), I notice that columns defined with char are given a collation by default:

COLLATE Latin1_General_BIN

How do I remove this? Could this be responsible for slow retrieval via MS Access linkage?

Thank you.

 

[sqlturbo]

In Query analyser, run this in the database your table is in.
ALTER TABLE Table_Name ALTER COLUMN ColName
datatype COLLATE collation_you_want

To change the defalut collation for the database, do a

ALTER DATABASE DBName COLLATE collation_you_want.
Note that the new collation for the database will be applied on objects created hereafter.