|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to do ...?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? Hi,
you can alter the current collation for a database by ALTER DATABASE statement ALTER DATABASE 'yourdb' COLLATE 'newcollation' AL -- Show quoteHide quotePlease 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) "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? > > >
Other interesting topics
More on querying remote server
many small queries vs one large query Plz help me! I want to use SQL Server2000 DTS Import/Export Wizard functionality from C# application Default Values for a Column 3 months after the layoff... "Colescing" values in a field? help with case Event Notification question Problem saving text to DB select specific child tables based on parent record |
|||||||||||||||||||||||