What's the equalent of rt_attr_string = col1 in SQL?

General Discussions - English
1

I have an rt index definition like

index aaa
{
    type = rt
    path = /var/lib/manticore/aaa
    rt_mem_limit = 512M
    stored_fields =
    min_word_len = 1
    min_prefix_len = 5
    rt_field = col1
    rt_field = col2
    rt_attr_string = col1
    rt_attr_string = col2
}

My question is how to create the same index using SQL?

2

here is an example Manticore Search Manual: Creating a table > Data types

CREATE TABLE products ( col1 string attribute indexed, col2 string attribute indexed );
3

Thank you, that works! However, I wonder if there’s a difference when I declare “col1 string attribute indexed” and “col1 text attribute indexed”?

The documentation seems to use “text” and not “string” at Manticore Search Manual: Creating a table > Local tables > Plain and real-time table settings

4

Thank you, that works! However, I wonder if there’s a difference when I declare “col1 string attribute indexed” and “col1 text attribute indexed”?

No difference.