Hi Shalin Thanks for your answer but it doesn't work just with Dfile.encoding I was hoping it could work.
I definitely can't change the database so I guess I must change java code. I've a function to change latin-1 string to utf8 but I don't know really where should I put it? Thanks for your answer, Shalin Shekhar Mangar wrote: > > Hi, > > The best way to manage international characters is to keep everything in > UTF-8. Otherwise it will be difficult to figure out the source of the > problem. > > 1. Make sure the program which writes data into MySQL is using UTF-8 > 2. Make sure the MySQL tables are using UTF-8. > 3. Make sure MySQL client connections use UTF-8 by default > 4. If the SQL written in your data-config has international characters, > start Solr with "-Dfile.encoding=UTF-8" as a command line parameter > > http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html > > I don't think there is any easy way to go about this. You may need to > revisit all the parts of your system. > > On Wed, Oct 22, 2008 at 12:52 PM, sunnyfr <[EMAIL PROTECTED]> wrote: > >> >> Hi, >> >> I'm using solr1.3 mysql and tomcat55, can you please help to sort this >> out? >> How can I index data in UTF8 ? I tried to add the parameter >> encoding="UTF-8" >> in the datasource in data-config.xml. >> >> | character_set_client | latin1 >> | character_set_connection | latin1 >> But data are stored in UTF8 inside database, not very logic but I can't >> change it. >> >> But still doesn't work, Help would be more than welcome, >> Thanks >> -- >> View this message in context: >> http://www.nabble.com/solr-1.3-database-connection-latin1-stored-utf8-in-mysql--tp20105301p20105301.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > -- > Regards, > Shalin Shekhar Mangar. > > -- View this message in context: http://www.nabble.com/solr-1.3-database-connection-latin1-stored-utf8-in-mysql--tp20105342p20106791.html Sent from the Solr - User mailing list archive at Nabble.com.
