[TYPO3-dev] OT: special characters in SQL

[Martin Kutschker]

Christian Lerrahn schrieb:
> 
> Fact is that I have a script that is completely encoded in UTF-8 and sends
> an SQL query to the server like "SELECT * FROM pages WHERE title LIKE
> 'Ü%'" but misses out a page called "Über uns" that I will find if I use
> the same query on phpmyadmin. So obviously the MySQL server is expecting
> something else but UTF-8! But will it always expect the same encoding?
> And which one would this be then?

(Newer) version support differen charsets for the server and the client. If 
they differ the data will be converted transparently. See mysql docs for 
charset support/config of mysql.

Masi