Re: Problem with COINTAINS

Tech-Archive recommends: Speed Up your PC by fixing your registry

paola wrote on Fri, 5 Jan 2007 08:35:01 -0800:

Sorry but I can't undestand...

My table contains:

id ds_job_location
-- -----------------------
1 REGGIO EMILIA
2 SAN SIRO
5 ALBAREDO PER SAN MARCO

and it doesn't contain "REGGIOLO", "SIROLO", "PERLO".

Why if I search "REGGIOLO" it returns the record with "REGGIO EMILIA",
if I search "SIROLO" it returns the record with "SAN SIRO" and
if I search "PERLO" il returns the record with "ALBAREDO PER SAN MARCO" ?

Why reggio is indexed as reggio and reggiolo?

Because, as Hilary pointed out, FTS using the Italian word breaker will
store both reggio and reggiolo in the catalog for that row.

Which are the rules that the italian word breaker use?

Why not just switch to the neutral word breaker, as that will give you
"english" style word matches (basically complete words with CONTAINS) rather
than language specific word stemming that you're seeing with the Italian
breaker.

Dan


.