Given the following CREATE TABLE statement:
CREATE TABLE [dbo].[Unit] ( [id] SMALLINT NOT NULL IDENTITY(1,1), [name] VARCHAR(100) NOT NULL, CONSTRAINT [PK_Unit] PRIMARY KEY CLUSTERED ([id]), CONSTRAINT [UQ_Unit_Name] UNIQUE ([name]) )
How to I allow the following two strings to co-exist without violating the UNIQUE constraint?
INSERT INTO dbo.Unit (Name) VALUES('e³m³/day') INSERT INTO dbo.Unit (Name) VALUES('e3m3/day')
Any insight appreciated.
Current Collation is
Unless someone has a better option, it appears that I may have to use Latin1_General_BIN and manually handle CI in the few places where I need it... will convert this to an answer if no better solutions are offered.