将gzcompress PHP字段添加到Sphinx Indexer问题中

Question

How to add on Sphinx Indexer to be able to index gzcompress rows from mysql database

I use gzcompress PHP function to encode the cache of each page, via PHP mysql the output is working with no issue via PHP Mysql but when i try to index the table to sphinx search engine the cache gzcompress is cut because of some symbols possible how i can fix this issue?

I don't get ERRORS when i use the Sphinx index command but is not getting the full code gzcompress.

source v_v1_src_p0
{
  type                    = mysql

  sql_host                = 
  sql_user                = 
  sql_pass                = 
  sql_db                  = 
  sql_port                = 3306  # optional, default is 3306

  sql_query = SELECT \
    id as id, \
    unique_id, \
    data_id, \
    data_title, \
    cache, \
    update_time, \
    total_updates \
    FROM cache_page WHERE id % 5 = 0;

  sql_field_string = unique_id
  sql_field_string = data_id
  sql_field_string = data_title
  sql_attr_string = cache
  sql_attr_uint = update_time
}

index data_v1_index_p0
{
    source                  = v_v1_src_p0
    path                    = /_data_v1/data_v1_index_p0
}