# Index data from mysql database error font utf8?

**URL:** <https://discuss.elastic.co/t/index-data-from-mysql-database-error-font-utf8/11091>\
**Category:** Elasticsearch\
**Created:** [March 11, 2013, 8:11am UTC](https://discuss.elastic.co/t/index-data-from-mysql-database-error-font-utf8/11091 "2013-03-11T08:11:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nhan248](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@nhan248](https://discuss.elastic.co/u/nhan248)\
**Post date:** [March 11, 2013, 8:11am UTC](https://discuss.elastic.co/t/index-data-from-mysql-database-error-font-utf8/11091/1 "2013-03-11T08:11:32Z")

</div>

Hi ,all  
i used plugin \_river and connect my mysql database with jdbc,however when i index data from table ,the return of data i get back display wrong with error font.  
i try to \<charset="utf-8"\> on html page but not fix .

curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{  
"type" : "jdbc",  
"jdbc" : {  
"driver" : "com.mysql.jdbc.Driver",  
"url" : "jdbc:mysql://localhost:3306/gate",  
"user" : "root",  
"password" : "root",  
"sql" : "select \* from news"  
},  
"index" : {  
"index" : "news",  
"type" : "news"  
}  
}'

=\>data getback : curl -XGET 'localhost:9200/news/news/\_search?pretty&q=\*'  
With error font : title "Xuất hiện game Tiên Tích tại VN" became:" Xuất hiện game Tiên Tích tại VN"

how i can fix it ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:47am UTC](https://discuss.elastic.co/t/index-data-from-mysql-database-error-font-utf8/11091/2 "2017-07-06T02:47:17Z")

</div>

Closed on July 6, 2017, 2:47am UTC