I'm trying to build a MySQL search query.
At Character Sets and Collations Supported by MySQL I can only spot two German collations:
It seems that latin1_german2_ci is the one you want, however it expects Latin1:
- Ä = AE
- Ö = OE
- Ü = UE
- ß = ss
If your table/column is not already using it, you can force such collation in the query itself, e.g.:
mysql> SELECT _latin1'oe' collate latin1_german2_ci ='ö' AS are_equal; +-----------+ | are_equal | +-----------+ | 1 | +-----------+ 1 row in set (0.00 sec)
If your application is using Latin1 this should do the trick. Otherwise, I honestly have no idea :)
Disclaimer: I know nothing about German. There may be another language that uses similar rules.