Hello,
I'm trying to import categorylinks.sql dump into my MySQL database. I'm
able to import it and query for articles in specific categories as long
the category name contains only English-language characters. I don't get
any results if I try to query for non-English category name. My
understanding is that the dump is in UTF-8 format so I tried the following:
create the database using the following command:
CREATE DATABASE wiki CHARACTER SET utf8 COLLATE utf8_general_ci;
import the dump using the following command:
mysql --user root --password=root wiki <
C:\Path\plwiki-20111227-categorylinks.sql --default-character-set=utf8
set my data source URL to the following in my Java code:
jdbc:mysql://localhost/plwiki?useUnicode=true&characterEncoding=UTF-8
It still doesn't work. What am I missing? Are there any instructions on
how to correctly import the dump anywhere?
Thanks,
Piotr