Hi Sundar

I’d not come across such a situation before. Yes, your fix will work 👍

Also, I’ve just modified the line you’ve pointed to so it’s now a partial match:
https://github.com/pat/thinking-sphinx/blob/develop/lib/thinking_sphinx/active_record/sql_source.rb#L17
 
<https://github.com/pat/thinking-sphinx/blob/develop/lib/thinking_sphinx/active_record/sql_source.rb#L17>

Cheers,

— 
Pat

> On 27 May 2017, at 1:47 am, Sundar Rajamanickam 
> <sundar.rajamanic...@chronus.com <mailto:sundar.rajamanic...@chronus.com>> 
> wrote:
> 
> Hi Pat
> 
> We migrated our DB from utf8 to utf8mb4 recently. So, we modified the 
> encoding in database.yml to utf8mb4.
> 
> Because of the code in 
> https://github.com/pat/thinking-sphinx/blob/cf16d18285e57e72d79234ec37ac8a5aa301296b/lib/thinking_sphinx/active_record/sql_source.rb#L17
>  
> <https://github.com/pat/thinking-sphinx/blob/cf16d18285e57e72d79234ec37ac8a5aa301296b/lib/thinking_sphinx/active_record/sql_source.rb#L17>,
>  the accented characters are now not getting indexed.
> 
> I have handled this by adding the following line to my ts-indices.
> 
> set_property utf8?: true
> 
> 
> Is this the right way to go about it!?
> 
> Thanks
> Sundar Raja
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to thinking-sphinx+unsubscr...@googlegroups.com 
> <mailto:thinking-sphinx+unsubscr...@googlegroups.com>.
> To post to this group, send email to thinking-sphinx@googlegroups.com 
> <mailto:thinking-sphinx@googlegroups.com>.
> Visit this group at https://groups.google.com/group/thinking-sphinx 
> <https://groups.google.com/group/thinking-sphinx>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.

-- 
You received this message because you are subscribed to the Google Groups 
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to thinking-sphinx+unsubscr...@googlegroups.com.
To post to this group, send email to thinking-sphinx@googlegroups.com.
Visit this group at https://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.

Reply via email to