snikolaev@dev:~$ mysql -P9306 -h0
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5185
Server version: 3.5.4 13f8d08@201211 release git branch HEAD (no branch)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create table idx(message text);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into idx values(123, 'message comes here');
Query OK, 1 row affected (0.74 sec)<?php
include('/usr/share/manticore/api/sphinxapi.php');
$cl = new SphinxClient();
$cl->SetServer('127.0.0.1', 9312);
$res = $cl->Query('@message here', 'idx');
print_r($res);
?>snikolaev@dev:~$ php test_sphinxapi_fields.php
Array
(
[error] =>
[warning] =>
[status] => 0
[fields] => Array
(
[0] => message
)
[attrs] => Array
(
[message] => 7
)
[matches] => Array
(
[123] => Array
(
[weight] => 1500
[attrs] => Array
(
[message] => message comes here
)
)
)
[total] => 1
[total_found] => 1
[time] => 0.366
[words] => Array
(
[here] => Array
(
[docs] => 1
[hits] => 1
)
)
)при загрузке charset_table отфильтровывать символы, которые встретились в ignore_chars
Посмотрим.