On 1/22/2013 8:33 AM, hassancrowdc wrote:
I thought that is the problem in the beginning but I have tried Kobo, but it does not give me result(numFound=0) If you want i can send you xml of resultset. and can you explain ho i can make it flexible so that it takes care of upper/lowercase or any other character? (I can't change the type of field as those are same as mysql type)
You can change the fieldType in Solr. It does not have to precisely match MySQL, it just has to be a compatible type. TextField (which is used in your schema fieldType called text) is compatible with almost any mysql field type. You would want to change the manufacturer, model, and perhaps displayName fields to a type of "text" ... if you need to do this kind of case-insensitive match on single words on any other fields, you'd want to change those fields too.
You may have to build additional fieldTypes with custom analyzer chains that do what you want rather than the example that you've got here. The "text" type you have defined is a very basic general-purpose type, but it won't work for everything.
If you do change your schema, you'll have to restart Solr and then do a full-import to erase your existing index and rebuild it.
Thanks, Shawn
