I think the closest collation in SQL Server is Finnish_Swedish_CI_AS. since you had swedish collation and case insensitive in MySql. The SQL Server collation is accent sensitive so if that's not correct use ..._AI
You can use this page
http://msdn.microsoft.com/en-us/library/ms188046.aspx[
^] to match the collations.
You can define the collation similarly in SQL Server, for more details, see
CREATE TABLE[
^] and the COLLATE keyword for columns.