For a specific column in a database running in SQL Server Express 2012, I need a sort where ss and ß are not considered the same when comparing strings. Also, ä and ae, ö and oe, ü and ue should be considered different, respectively. Latin1_General_CI_AS provides the latter, but ss and ß are not different. That is, WHERE ThatColumn = 'Fass'give both Fassand Faß.
I would just stick with BIN / BIN2, but I need case insensitivity. If nothing else works, I will have to use Latin1_General_BIN / Latin1_General_BIN2 and make sure everything is uppercase or lowercase. That would mean a lot of work, since I also needed to get a version with the appropriate case.
But if there is a sort that does what I need, please let me know. Thanks in advance!
Update: Additional requirements information: the database contains personal names from a legacy system that only supports ASCII characters. That is, names such as Mueller and Fas are stored as Mueller and Fass. In the new system, the user will have a function to rename these persons, for example. rename "Muller" to "Muller". To find objects that need to be renamed, I need to find strings containing, for example. Fassa. But since now the query also returns “Faß”, which I don’t want. I still need / need case insensitivity, since the user should be able to search for "face" and still get "Fass".
There is more in the system, but I can finally say that I need to distinguish between ss and ß, ä and ae, etc.
source
share