Re: Garbled data in response - reading from mySQL database

2009-10-03 Thread Lance Norskog
In general it is easier to use the DIH with a database view, rather than embedding the query in the DIH configuration file. On Sat, Oct 3, 2009 at 2:08 AM, Ade B wrote: > > Perfect, thank you. > > Ade > > > > -- > View this message in context: > http://www.nabble.com/Garbled-data-in-response---r

Re: Garbled data in response - reading from mySQL database

2009-10-03 Thread Ade B
Perfect, thank you. Ade -- View this message in context: http://www.nabble.com/Garbled-data-in-response---reading-from-mySQL-database-tp25726655p25726976.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Garbled data in response - reading from mySQL database

2009-10-03 Thread Avlesh Singh
Change concat(i.name,'|',ih.name,'|',i.id) to *cast(*concat(i.name,'|', ih.name,'|',i.id)* as char)* Cheers Avlesh On Sat, Oct 3, 2009 at 1:51 PM, Ade B wrote: > > Hi > > I am using the DIH to import data from a mySQL database. Everything was > fine > in that I could index the data, and search t