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.
