Text fields are tokenized on whitespace and punctuation. Searches are case-insensitive.
For example, the string from the product_name field:
Microsoft Visual Studio 2010
is interpreted as
microsoft AND visual AND
Searches for any of these strings will match on the binary. Phrase queries for any two consecutive terms also match on the binary.
product_name: "visual studio"