Contains + Special caractere

When I execute this request
select *
from fiche
where contains(numerofiche,'A30/05')
I get all the row where numerofiche contains 05. Does it come from the
caractere "/"? Is there a way to get exactly the row containing exactly
"A30/05" using the contains predicat.
Thanks
I don't get this result.
What word breaker are you using, French, neutral, or another language?
Do you get this result if you wrap your search phrase in double quotes?
"Cedric DEBARD" <charrue21@.ifrance.com> wrote in message
news:OxSfGRxwEHA.1192@.tk2msftngp13.phx.gbl...
> When I execute this request
> select *
> from fiche
> where contains(numerofiche,'A30/05')
> I get all the row where numerofiche contains 05. Does it come from the
> caractere "/"? Is there a way to get exactly the row containing exactly
> "A30/05" using the contains predicat.
> Thanks
>
|||what do you mean by "word breaker". I'm using a french version of SQL Server
2000
If I execute the request:
select *
from fiche
where contains(numerofiche,'"A30/05"')
I've got the same set of results
numerofiche
A30/05
C99/05
E 05
05
H 05
"Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
news:ubME$LzwEHA.3844@.TK2MSFTNGP09.phx.gbl...
> I don't get this result.
> What word breaker are you using, French, neutral, or another language?
> Do you get this result if you wrap your search phrase in double quotes?
>
> "Cedric DEBARD" <charrue21@.ifrance.com> wrote in message
> news:OxSfGRxwEHA.1192@.tk2msftngp13.phx.gbl...
>
|||The default for a french version of SQL Server will be using the french word
breaker.
You can verify this by doing the following:
sp_help_fulltext_columns 'TableName' and then noting the number for the
FullText_Language column. It should be 1036. You can get the language which
matches this by issuing a xp_MSFullText which will display a list of
languages and their LocID which corresponds to the value in the
FullText_Language column.
I do get this behavior with the French Word breaker, but not the English
ones or the neutral word breaker.
Are you doing any inflectional or FreeText searches? If not, your best
optioin might be to use the neutral word breaker.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Cedric DEBARD" <charrue21@.ifrance.com> wrote in message
news:ujzUBdzwEHA.2016@.TK2MSFTNGP15.phx.gbl...
> what do you mean by "word breaker". I'm using a french version of SQL
Server[vbcol=seagreen]
> 2000
> If I execute the request:
> select *
> from fiche
> where contains(numerofiche,'"A30/05"')
> I've got the same set of results
> numerofiche
> A30/05
> C99/05
> E 05
> 05
> H 05
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
> news:ubME$LzwEHA.3844@.TK2MSFTNGP09.phx.gbl...
exactly
>
|||another option is to replace the / with a _
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Cedric DEBARD" <charrue21@.ifrance.com> wrote in message
news:ujzUBdzwEHA.2016@.TK2MSFTNGP15.phx.gbl...
> what do you mean by "word breaker". I'm using a french version of SQL
Server[vbcol=seagreen]
> 2000
> If I execute the request:
> select *
> from fiche
> where contains(numerofiche,'"A30/05"')
> I've got the same set of results
> numerofiche
> A30/05
> C99/05
> E 05
> 05
> H 05
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
> news:ubME$LzwEHA.3844@.TK2MSFTNGP09.phx.gbl...
exactly
>
|||BTW - you'ld have to do this replacement on your content as well in your
search phrases.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ual$280wEHA.2676@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> another option is to replace the / with a _
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Cedric DEBARD" <charrue21@.ifrance.com> wrote in message
> news:ujzUBdzwEHA.2016@.TK2MSFTNGP15.phx.gbl...
> Server
quotes?[vbcol=seagreen]
the
> exactly
>