[TYPO3-dev] OT: special characters in SQL

[Christian Lerrahn]

On Wed, 15 Mar 2006 13:43:22 +0100
Martin Kutschker <Martin.Kutschker at n0spam-blackbox.net> wrote:

> 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.

On the development box I gotthis to work by converting the script from
UTF-8 to ISO8859-15. However, this is probably not universal. I just have
no idea, how you would make it universal...

Christian

-- 
    Er  deckt  mich  in seiner Hütte zur bösen Zeit, er birgt mich im
    Schutz seines Zeltes.
    
    Psalm 27,5
    
    "Die Oberen des Volkes sahen den Freimut des Petrus und  Johannes
    und  wunderten  sich;  denn  sie merkten, dass sie ungelehrte und
    einfache Leute waren, und wussten auch von ihnen,  dass  sie  mit
    Jesus gewesen waren."
    
    Apostelgeschichte 4,13