How to do ...?

6 Apr 2006 4:00 PM

Bpk. Adi Wira Kusuma

When I install SQL Server 2000, I wanna make a server have
"Latin1_General_CI_AS" Collation.What Must I set on Collation setting?

If I install in Win2000 server and when on Collation setting, I choose
option "SQL Collations...", and select "Dictionary order,
Case-insensitive,...". So the server will not be "Latin1_General_CI_AS"
Collation. But When I install it on Win98, the server will be
"Latin1_General_CI_AS" Collation. Why?

Oh yeah, If the server has been a certain collation. Can I change collation
on a database away?

6 Apr 2006 4:41 PM

Enric

Hi,
you can alter the current collation for a database by ALTER DATABASE statement

ALTER DATABASE 'yourdb' COLLATE 'newcollation'

AL

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)

Show quoteHide quote

"Bpk. Adi Wira Kusuma" wrote:

> When I install SQL Server 2000, I wanna make a server have
> "Latin1_General_CI_AS" Collation.What Must I set on Collation setting?
>
> If I install in Win2000 server and when on Collation setting, I choose
> option "SQL Collations...", and select "Dictionary order,
> Case-insensitive,...". So the server will not be "Latin1_General_CI_AS"
> Collation. But When I install it on Win98, the server will be
> "Latin1_General_CI_AS" Collation. Why?
>
> Oh yeah, If the server has been a certain collation. Can I change collation
> on a database away?
>
>
>