CODEWITHSUNDEEP
mysqlsphinxcollation
Y. E.
Y. E.

Reputation: 784

sphinx collation when mysql collation is utf8_unicode_ci

Which collation would be better to set in Sphinx config file if utf8_unicode_ci is used in searchable MySQL table? I'd like to be able to sort searched data taking in notice umlauts (accents), case insensitive.

P.S. I'm reading http://sphinxsearch.com/docs/2.0.6/collations.html at the moment, but not everything is clear to me.

Thank you.

Upvotes: 3

Views: 1285

Answers (1)

aditirex
aditirex

Reputation: 692

Make sure you use in source configuration sql_query_pre = SET NAMES utf8 , in index configuration charset_type = utf-8 and you need to add to the default charset_table utf codes for umlauts, for example, check http://sphinxsearch.com/wiki/doku.php?id=charset_tables

Upvotes: 2

Related Questions