SQL 2012 collation - space and Currency Kip (₭) equal duplicate key
===

I have built my database with SQL_Latin1_General_CP1_CI_AS collation.

I have built a table with a column with CONSTRAINT [Column_C] UNIQUE NONCLUSTERED; the problem I have now is that the Column_C include duplicate key: space and Currency Kip (₭).

I assume I have selected wrong collation for my SQL 2012.

My goal is to include all characters into one database, the sort order is not that important; but I need the SQL server to separate the characters from each character. Space and Currency Kip (₭) cannot be space; but two different characters.

Do you have any suggestion to help me?

Thank You,
Rune