How to index and select very long text (LONGTEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci' from mysql)

General Discussions - English
1

Hello ,
I need to index a mysql table where a have a longtext field (over 1 millions caracters), i can index all fields, but when i do a select * query, the big text field return empty value. Mysql field was declared as LONGTEXT NULL DEFAULT NULL COLLATE ‘utf8_general_ci’.

Any tips ?
Thanks

2

could you provide example of your config \ table description?

As from issue description it is not clear

  • is the full-text matching returns empty result set
  • is the stored fields become empty at the result set
  • is the attribute become empty at the result set
3

Thanks for your answer, i have used another solution, i create chunks part of the big text. Sorry for the delay