MySQL COLLATION descriptions aren't matching MSSQL

[acnicholls]

Msg 448, Level 16, State 2, Line 29
Invalid collation 'utf8_general_ci'.

find the equivalent and write a function that corrects each collation to the proper MSSQL standard

string ConvertCollate(string MySQLCollate)
{
    switch(MySQLCollate)
    {
        case "utf8_general_ci":
        {
            return "whatever_it_is";  // SQL_Latin1_General_CP1_CI_AS is SQLServer default
            break;
        }
        // etc...
    }
}