Collation Question

[bangalibhai]

Hi,

I have the below in one of my stored procedures.

Declare @tmp table(OptionCod e varchar(2) COLLATE SQL_Latin1_Gene ral_CP1_CS_AS PRIMARY KEY CLUSTERED)

Record #1: "TP"
Record #2: "Tp"

1st record is insrted in to the above table and as soon as the second record is added "Violation of PRIMARY KEY constraint" error is thrown. Any idea why it would do that even though I have the specific column specified as case sensitive.

Thanks in advance.

[debasisdas]

As you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR