To be able to store all characters you should use nvarchar() or nchar() (as opposed to varchar() or char()) everywhere where the values are stored. i.e. in all your tables, variables and constants.

A text constant is made into a n-type by prefixing it with a capital N. For example:

declare @txt nvarchar(100);

select @txt = N'test';