Hi,

I would like to know if the Sphinx engine works with any delimiters (like commas and periods in normal MySQL). My question comes from the urge, not to use them at all, but to escape them or at least thay they don't enter in conflict when performing MATCH operations with FULLTEXT searches, since I have problems dealing with them in MySQL by default and I would prefer not to be forced to replace those delimiters by any other characters to provide a good set of results.

Sorry if I'm saying something stupid, but I don't have experience with Sphinx or other complementary (?) search engines.

To give you an example, if I perform a search with

"Passat 2.0 TDI"

MySQL by default would identify the period in this case as a delimiter and since the "2" and "0" are too short to be considered words by default, the results would be a bit messed up.

Is it easy to handle with Sphinx (or other search engine)? I'm open to suggestions.

This is for a large project, with probably more than 500.000 possible records (not trivial at all).

Cheers!