Thanx for all James, the problem was my database. Moved it to utf8, but still had some unicode strange chars... now my database is clean and working on utf8. Your charset_table works like a charm, and you guy rule a lot =D
Thanx!! Iván On Apr 8, 8:05 am, Iván Belmonte <[email protected]> wrote: > No way man, my database is now UTF-8, but sphinx does not index any > record containing an accent. > My charset_table is the one from your post... don't know what more to > do or read... > > On Apr 8, 5:42 am, Iván Belmonte <[email protected]> wrote: > > > Definitely i'm converting my database into utf-8 > > > Will advise you if it explodes heheh > > > Iván > > > On Apr 8, 4:57 am, James Healy <[email protected]> wrote: > > > > IvanHQ wrote: > > > > Yes, your options work, now my sphinx indexes documents and gives no > > > > error. > > > > But it doesn't index any document containing accents. > > > > MySQL default charset is latin1, so maybe it is the root of the > > > > problem. Is > > > > there any way to solve it while using latin1? or should I convert all > > > > the > > > > database to utf-8? > > > > That could be your issue - I know my database is encoded as utf-8. > > > > Converting the encoding of a database is generally non trivial - I'd > > > suggest testing the theory first, before you spend a long time > > > converting your own DB. > > > > You might also try explicitly setting the encoding in your sphinx config: > > > > charset_type: utf-8 > > > > I think TS defaults to this, but it can't hurt to double check. > > > > -- James Healy <jimmy-at-deefa-dot-com> Wed, 08 Apr 2009 12:46:12 +1000 > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
