Select Options with special entities (ä-a, ö-a, ü-u, ß-s)

[Alf S.]

I neded these options in a Select Options field:

a
ä

an I got an SQL error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'ä-123' for key 'title'

The same with o/ö, u/ü and s/ß. Obviously for SQL these characters are the same. (They should be ä=ae, ü=ue, ö=oe, ß=ss )

This works:

1=a|a
2=ä|ae

but in the backend I have ae instead of ä...

FInally I ended up with this ugly solution:

1=a|"a"
2=ä|'ä'
3=b|"b"
4=c|"c"
...

Any better suggestions?