[TYPO3-dev] OT: special characters in SQL

[Martin Kutschker]

Christian Lerrahn schrieb:
> If I write e.g. an "ö", the editor will choose some encoding
> which might be different from the server's default.

How come? Where does the editor enter the strings? The charset of FE and BE 
is known, so you can do any transformation you might want. But betware not 
all languages have a correct sorting if you simply strip any accents and eg 
Spanish regards "ll" as a distintc character (sorted I think after "l").

If you simply want to strip the accents use t3lib_cs->specToAscii(). 
Otherwise store your data in UTF-8 and follow Dimitri's advice and use 
Mysql's collate feature.

Masi