• You won't need to change the collation at all.

    The reason it is not storing unicode is because you are not passing the string as Unicode.

    add the leading unicode N before your string and this will work.

    eg

    INSERT INTO [test1] (

    [title]

    ) VALUES (N'FceRI-mediated activity' )