Suitable replacement for SQL_Latin1_General_CP1_CI_AS (SQL Server 2012 ) -

i'm looking replacement latin1_general_ci_as need differentate between ß , ss , found sql_latin1_general_cp1_ci_as. problem collation though is merely legacy collation , should avoided if possible.

now question is there collation provides same functionalities legacy one?

edit: info here need have collation case insensitive run troubles else statements. additionally i'm using c#'s entity framework gather data need avoid possibilities result in special statements (such using convert in statement)

try this

select * convert(varbinary,word)=convert(varbinary,'search') 

or

select * convert(varbinary,upper(word))= convert(varbinary,upper('search')) 

or

select * convert(varbinary,lower(word))= convert(varbinary,lower('search'))