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 -~----------~----~----~----~------~----~------~--~---
