/trunk/papyrus/applettes/moteur_recherche/sphinx-min.conf |
---|
16,7 → 16,8 |
sql_pass = |
sql_db = raphdb |
sql_sock = /home/raphael/web/mysql/mysql.sock |
sql_query_pre = SET NAMES utf8 |
#sql_query_pre = SET NAMES utf8 |
sql_query_pre = SET NAMES latin1 |
} |
228,8 → 229,9 |
workers = threads # for RT to work |
binlog_path = /var/lib/sphinx |
collation_server = utf8_general_ci # unsure |
collation_libc_locale = fr_FR.UTF-8 |
#collation_server = utf8_general_ci # unsure |
#collation_libc_locale = fr_FR.UTF-8 |
# collation_libc_locale = fr_FR@euro |
# collation_libc_locale = fr_FR@euro |
} |
/trunk/papyrus/applettes/moteur_recherche/moteur_recherche_sphinx.php |
---|
261,3 → 261,10 |
$s->setMaxQueryTime(3); |
var_dump($s->query("test")); |
*/ |
/* |
Note: conversion côté client SQL: |
mysql -h0 -P 9306 < <(iconv -f utf8 -t latin1 <<<"SELECT * FROM i_projet, i_spip, i_papyrus, i_bazar WHERE MATCH('journée');") |
*/ |