Collation Type 
Author Message
 Collation Type
Is there a way to view and change the collation method on a databasde in SQL
Server?


Sat, 22 May 2004 04:37:06 GMT
 Collation Type

Zvi Ginsberg,
Assuming its SQL2000....

To view:

--server level

sp_helpsort or
SELECT   CONVERT(char(60), SERVERPROPERTY('collation'))

--database level
sp_helpdb <databasename>

--tablelevel(for each columns indiv.)

sp_help <tablename>

To change:

--server level

rebuild master database

--database level

ALTER DATABASE databasename COLLATE....

--table level

ALTER TABLE tablename ALTER COLUMN columnname COLLATE...

Dinesh.


Quote:
> Is there a way to view and change the collation method on a databasde in
SQL
> Server?



Sat, 22 May 2004 04:55:38 GMT
 Collation Type
Thank You very much!



Quote:
> Zvi Ginsberg,
> Assuming its SQL2000....

> To view:

> --server level

> sp_helpsort or
> SELECT   CONVERT(char(60), SERVERPROPERTY('collation'))

> --database level
> sp_helpdb <databasename>

> --tablelevel(for each columns indiv.)

> sp_help <tablename>

> To change:

> --server level

> rebuild master database

> --database level

> ALTER DATABASE databasename COLLATE....

> --table level

> ALTER TABLE tablename ALTER COLUMN columnname COLLATE...

> Dinesh.



> > Is there a way to view and change the collation method on a databasde in
> SQL
> > Server?



Sat, 22 May 2004 05:08:04 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How do you check the Collation Type of just a Coloum in SQL 2000

2. SQL-Server collation type & OLE-DB Providers

3. Default collation on data type 'table'?

4. Windows Collation VS SQL Collation

5. server collation vs database collation issue

6. data of 950 collation within database of 936 collation

7. Type, sub-type, and sub-sub-type database design

8. Data Type transparent to the type of the table field

9. Need Help passing SQL type float to appear at type double in ODS DLL

10. type mismatch error while importing data to a BIT type column

11. Type Mismatch while using Activex Script Task with numeric data type

12. How to Create SQL Server Resource Type, SQL Server Agent Resource Type


 
Powered by phpBB® Forum Software