On 01/03/07, KimToner <garbageboxe(a)gmail.com> wrote:
I make some select from wikimedia categorylinks table
on a local DB.
"SELECT cl_from FROM categorylinks WHERE cl_to = $catname;"
For categories with accents in the name, i cannot get any results.
I've tried to encode the $catName in latin1, utf-8 and even tryed to URL
encode both versions.
No luck...
The MySQL instance is configured with default values for the encoding.
* URL to the dump file used
* MySQL version
The data will typically be UTF-8 stored inside a latin1 database.
MySQL may have tried to be "helpful" by converting it during import,
which typically screws everything up.
Rob Church