On 01/03/07, KimToner garbageboxe@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