MS SQL unique key - bug or feature?

Question

I have a table in MS SQL where I have a TERMINAL varchar(50) column and I have a unique key on it. I get a UK key violation exception when I try to insert record 'HOST1' and then 'HOST1 '. Why MS sql handles these two strings as they would be the same?

Thanks Z

Answer 1

I believe that MS SQL strips the white space at the end for VARCHAR.