| /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');") |
| */ |