#community-help

Querying with Special Characters in Collections

TLDR Hariharan asked about querying with special characters. Kishore Nallan explained to use symbols_to_index configuration while creating the collection.

7mo

Join the chat

Mar 14, 2023 (7 months ago)

Photo of md5-18c41204e6fd9bb8436d758a90a0e5ef

Hariharan

09:03 AM

Hi! Is it possible to query using special characters? Currently search query with only special characters results in showing all records. But expectation is not to return any data if no special characters in the field which we search.

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

12:32 PM

Yes, please use symbols_to_index configuration while creating the collection.

12:33

Kishore Nallan

12:33 PM

curl -k "" -X POST -H "Content-Type: application/json" \                                                                                                                        
      -H "X-TYPESENSE-API-KEY: ${TYPESENSE_API_KEY}" -d '{
        "name": "coll_name",
        "fields": [           
          {"name": "title", "type": "string" }
        ], "symbols_to_index": ["+"]
      }'

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2776 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Handling Special Characters in Search Queries

Sidharth asks how to handle special characters in search queries. Kishore Nallan suggests using `symbols_to_index` configuration and provides an example to help.

4mo

Querying Special Characters in Database

robert had difficulty searching for `$` in documents. Jason explained how to include special characters in search indexing.

15mo

Query on Typesense Indexing Special Characters

JinW inquired about Typesense indexing .(period) and synonyms stripping out the period, Jason clarified that from version 0.22, Typesense can index special characters and suggested using 0.22.0.rcs39.

23mo