sphinx åäö

sphinx.conf.part

source loppis_posts
{
type = mysql

sql_host = localhost
sql_user = user
sql_pass = pass
sql_db = loppis_dev
sql_port = 3306 # optional, default is 3306

  sql_query_pre = SET SESSION query_cache_type=OFF
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT post_id, from_name, message, UNIX_TIMESTAMP(created_time) AS created_timestamp FROM posts \
                    WHERE deleted = 0 \
                    AND duplicate_post_id IS NULL \
                    AND created_time > DATE_SUB(NOW(), INTERVAL 1 MONTH)

  sql_attr_timestamp = created_timestamp
}


index loppis_posts_index
{
source = loppis_posts
path = /var/www/dev.loppis/sphinx/var/data/loppis_posts
docinfo = extern
charset_type = utf-8
  charset_table = A..Z->a..z, _, -, a..z, \
    U+D6->o, U+D6->U+F6, U+F6, \
    U+C4->a, U+C4->U+E4, U+E4, \
    U+C5->a, U+C5->U+E5, U+E5, \
    U+C9->e, U+C9->U+E9, U+E9
  min_infix_len=2

}