Hello,
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.
Am i missing something here? Would someone have a hint?
thanks,
Kim
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
Hi Rob,
Thanks for your answer. This is unfortunately exactly the case. I've got to deal with this...
Kim
mediawiki-l@lists.wikimedia.org