What I mean is that unless "solène" travels to Solr in strict UTF-8, mapping-ISOLatin1Accent won't do anything, and posibly your DB query returns data in ISO-Latin1 (I always have this issue with UTF8-Mysql), so unless you transcode your data from Latin1 to UTF8 before sending it to SolR, mapping-ISOLatin1Accent won't know how to interpret it.
Does it make any sense? :P On Fri, Mar 20, 2009 at 11:53 AM, aerox7 <amyne.berr...@me.com> wrote: > > I'm using DataImportHandler to send my data to Solr ! so you mean it > possible > to apply a transformer in db-config.xml with a perl script ? > > > Óscar Marín Miró wrote: > > > > Hi, > > > > My guess is that *although* your DB is in UTF-8, the database engine > sends > > you the rows in ISO-Latin1, so before doing *anything* after receiving > the > > data, you should transcode from ISO-Latin1 to UTF-8 and then send that to > > SolR. I'm no Java expert, but in perl (MySQL DB in utf-8) I have to do > > with > > any row: > > > > $row=decode("iso-8859-1",$row); > > > > ... and before building the xml to invoque and add document to SolR: > > > > $row=encode("utf8",$row); > > > > On Fri, Mar 20, 2009 at 10:55 AM, aerox7 <amyne.berr...@me.com> wrote: > > > >> > >> I add : > >> "è" => "e" to mapping-ISOLatin1Accent.txt > >> > >> and add the following fieldType: > >> > >> <fieldType name="textCharNorm" class="solr.TextField" > >> positionIncrementGap="100" > > >> <analyzer> > >> <charFilter class="solr.MappingCharFilterFactory" > >> mapping="mapping-ISOLatin1Accent.txt"/> > >> <tokenizer class="solr.CharStreamAwareWhitespaceTokenizerFactory"/> > >> </analyzer> > >> </fieldType> > >> > >> By still have the same probleme ! it's only work when i store ISO string > >> into UTF-8 data base (ex: store solène not solène)............ :,( > >> > >> > >> > >> > >> aerox7 wrote: > >> > > >> > ==> where are you seeing it as ""Solène" as opposed to the > >> > correct way of solène? > >> > > >> > I have "Solène" in my Mysql DATA BASE ! so i don't know if this is > >> > correct or not ? i gess that "Solène" is solène in UTF-8 ?! > >> > > >> > I'vz tryed analysis in http://localhost:8983/solr/admin/analysis.jsp, > >> so > >> > when i try with solène everything is ok ! but when i try with Solène > >> > (like what i have in DB) analysis convert à in A delete ¨ so i get > >> SolAne > >> > !!! > >> > > >> > I think that ISOLatin1AccentFilterFactory take only string with > Charset > >> > ISO-8859-1 . > >> > > >> > So any solution to transform my string to ISO-8859-1 before indexing > >> > process. May be by creating transformer in DataImportHandler ? (Never > >> code > >> > in java :( ) > >> > > >> > Thank you all. > >> > > >> > > >> > Koji Sekiguchi-2 wrote: > >> >> > >> >> aerox7 wrote: > >> >>> Hi, > >> >>> I have a mysql data base in UTF-8. I have a row with "Solène" > >> (solène). > >> >>> I > >> >>> want to transforme this to solene, so i use Solr > >> >>> ISOLatin1AccentFilterFactory to perform this task but it dosn't work > >> ?!! > >> >>> > >> >>> i gess that "Solène" is "solène" in UTF-8 ?! i also set tomcat to > >> utf-8 > >> >>> so > >> >>> normaly ISOLatin1AccentFilterFactory have to replace the accent > >> ....... > >> >>> > >> >>> any ideas ? > >> >>> > >> >>> i use DataImportHandler. > >> >>> > >> >> > >> >> If a mapping rule "è" to "e" is always true in your field, you can > >> try > >> >> to use MappingCharFilter > >> >> instead of ISOLatin1AccentFilter. Add the following line to > >> >> mapping-ISOLatin1Accent.txt: > >> >> > >> >> "è" => "e" > >> >> > >> >> and add the following fieldType: > >> >> > >> >> <fieldType name="textCharNorm" class="solr.TextField" > >> >> positionIncrementGap="100" > > >> >> <analyzer> > >> >> <charFilter class="solr.MappingCharFilterFactory" > >> >> mapping="mapping-ISOLatin1Accent.txt"/> > >> >> <tokenizer > >> class="solr.CharStreamAwareWhitespaceTokenizerFactory"/> > >> >> </analyzer> > >> >> </fieldType> > >> >> > >> >> MappingCharFilter and mapping-ISOLatin1Accent.txt are in nightly > >> build. > >> >> > >> >> Koji > >> >> > >> >> > >> >> > >> >> > >> > > >> > > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/Problem-with-UTF-8-and-Solr-ISOLatin1AccentFilterFactory-tp22607642p22617278.html > >> Sent from the Solr - User mailing list archive at Nabble.com. > >> > >> > > > > > > -- > > “I may not believe in myself, but I believe in what I'm doing.” > > > > -- Jimmy Page > > > > > > -- > View this message in context: > http://www.nabble.com/Problem-with-UTF-8-and-Solr-ISOLatin1AccentFilterFactory-tp22607642p22618085.html > Sent from the Solr - User mailing list archive at Nabble.com. > > -- “I may not believe in myself, but I believe in what I'm doing.” -- Jimmy Page