A
A
Andrey Panov2014-07-10 09:34:34
Sphinx
Andrey Panov, 2014-07-10 09:34:34

MS-SQL. Why are the results returned by RPC truncated?

Good afternoon.
Available: MS-SQL Server 2012 to which Sphinx (version 2.2.3) is connected via Linked Server using the MySql ODBC 5.1 driver.
Problem: when calling the "CALL SNIPPETS" function, the returned data is truncated by 85 characters, regardless of the parameters passed to the function.
Through the MySql console client, the results are returned correctly.
Query like:
EXEC('text1 test text2 text3 test text4 text5 test text6 text7 test text8 text9 test text10 text11 test text12 text13 test text14 text15 test text16',testIndex,'test',1 AS query_mode,5 as around,100 as LIMIT)
Returns the following response:
... <open tag>test<close tag> text10 text11 <open tag>test<close tag> text12 text13 <open tag>test<close tag> text14 text15 <open tag

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question