Hi, I'm trying to index data from mysql. The indexing is successful. Then I tried to use the mysql concat function (data-config.xml) in order to concatenate a custom string with a field like this: *CONCAT('(', CAST('ΤΜΗΜΑ' AS CHAR CHARACTER SET utf8), ' ', apofasi_tmima, ')') *. The custom string ('ΤΜΗΜΑ') in Greek. Then when I try to query the field solr returns "?????" instead of "ΤΜΗΜΑ". I have also use this: *CONCAT('(', 'ΤΜΗΜΑ', ' ', apofasi_tmima, ')')* with no success. The "data-config.xml" file is utf-8 encoded and at the beginning there is the "<?xml version="1.0" encoding="UTF-8"?>" xml directive. I have also tried to set in the dataSource url “characterEncoding=utf8” but indexing fails. What am I missing here? Is there any workaround for this? Below is a snippet from data-config.xml:
<?xml version="1.0" encoding="UTF-8"?> <dataConfig> <dataSource type="JdbcDataSource" autoCommit="true" batchSize="-1" convertType="false" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/apofaseis?zeroDateTimeBehavior=convertToNull" user="root" password="xxxx" name="db" /> <dataSource name="fieldReader" type="FieldStreamDataSource" /> <document> <entity name=" apofaseis _2000 " dataSource="db" transformer="HTMLStripTransformer" query="select id, CONCAT_WS('', CONCAT(apofasi_number, '/', apofasi_date, ' ', (CASE apofasi_tmima WHEN NULL THEN '' WHEN '' THEN '' ELSE CONCAT('(', CAST('ΤΜΗΜΑ' AS CHAR CHARACTER SET utf8), ' ', apofasi_tmima, ')') END))) AS grid_title, CAST(CONCAT_WS('_',id,model) AS CHAR) AS solr_id, apofasi_number, apofasi_date, apofasi_tmima, CONCAT(IFNULL(apofasi_thema, ''), ' ', IFNULL(apofasi_description, ''), ' ', apofasi_body) AS content, type, model, url, search_tag, last_modified, CONCAT_WS('', CONCAT(apofasi_number, '/', apofasi_date, ' ', (CASE apofasi_tmima WHEN NULL THEN '' WHEN '' THEN '' ELSE CONCAT('(', CAST('ΤΜΗΜΑ' AS CHAR CHARACTER SET utf8), ' ', apofasi_tmima, ')') END))) AS title from apofaseis _2000 where type = 'text'" ... ... Regards, anarchos78 -- View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-Mysql-concat-issues-tp4137814.html Sent from the Solr - User mailing list archive at Nabble.com.