-- Supported Collations: -- SELECT * FROM sys.fn_helpcollations() WHERE name LIKE 'SQL%' USE [Master] GO ALTER DATABASE [DatabaseName] COLLATE SQL_Latin1_General_CP437_BIN2 GO
ALTER TABLE dbo.MyTable ALTER COLUMN CharCol VARCHAR(10) COLLATE SQL_Latin1_General_CP437_BIN2 NOT NULL; GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)