Different result when using Indexing Service Query Form and SQL Server

When I use the "Indexing Service Query Form", searching documents for
the word "D=E9sir=E9", I get 50 matched records.
If I run the following query from SQL-Server 2005 (on the same machine)
:
SELECT * FROM
OPENQUERY
(CVCATALOG,
'SELECT FILENAME, RANK FROM SCOPE()
WHERE CONTAINS(''"d=E9sir=E9"'')
')
I only get 45 results.
This seems to be linked to the special characters (=E9) since it gives
the same result if I specify a word without accents.
Any idea?
By default IIRC SQL Server 2005 is accent insensitive whereas indexing
services is not. You have the option of making your catalog accent
sensitive.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<pierre.laduron@.thalesgroup.com> wrote in message
news:1160492048.051686.161080@.i3g2000cwc.googlegro ups.com...
When I use the "Indexing Service Query Form", searching documents for
the word "Dsir", I get 50 matched records.
If I run the following query from SQL-Server 2005 (on the same machine)
:
SELECT * FROM
OPENQUERY
(CVCATALOG,
'SELECT FILENAME, RANK FROM SCOPE()
WHERE CONTAINS(''"dsir"'')
')
I only get 45 results.
This seems to be linked to the special characters () since it gives
the same result if I specify a word without accents.
Any idea?
|||Hello Hilary,
Thanks for your quick reply. This seems to be an interesting track.
Can you tell me how I can make the catalog accent sensitive?
Thanks again,
Pierre
Hilary Cotter wrote:
> By default IIRC SQL Server 2005 is accent insensitive whereas indexing
> services is not. You have the option of making your catalog accent
> sensitive.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <pierre.laduron@.thalesgroup.com> wrote in message
> news:1160492048.051686.161080@.i3g2000cwc.googlegro ups.com...
> When I use the "Indexing Service Query Form", searching documents for
> the word "D=E9sir=E9", I get 50 matched records.
> If I run the following query from SQL-Server 2005 (on the same machine)
> :
> SELECT * FROM
> OPENQUERY
> (CVCATALOG,
> 'SELECT FILENAME, RANK FROM SCOPE()
> WHERE CONTAINS(''"d=E9sir=E9"'')
> ')
> I only get 45 results.
> This seems to be linked to the special characters (=E9) since it gives
> the same result if I specify a word without accents.
> Any idea?
|||use the alter fulltext catalog statement. Here is an example.
Warning - this will entail a catalog rebuild.
Create database fulltext
GO
create fulltext catalog testcatalog
GO
--this may return an erroneous result - consult
http://support.microsoft.com/?kbid=910067 for more info
select fulltextcatalogproperty('testcatalog','isaccentsen sitive')
GO
select is_accent_sensitivity_on from sys.fulltext_catalogs where
name='testcatalog'
GO
--setting it off
alter fulltext catalog testcatalog
rebuild with ACCENT_SENSITIVITY =OFF
GO
select fulltextcatalogproperty('testcatalog','isaccentsen sitive')
GO
select is_accent_sensitivity_on from sys.fulltext_catalogs where
name='testcatalog'
GO
--setting it on
alter fulltext catalog testcatalog
rebuild with ACCENT_SENSITIVITY =ON
GO
select fulltextcatalogproperty('testcatalog','isaccentsen sitive')
GO
select is_accent_sensitivity_on from sys.fulltext_catalogs where
name='testcatalog'
GO
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<pierre.laduron@.thalesgroup.com> wrote in message
news:1160557828.399727.117000@.c28g2000cwb.googlegr oups.com...
Hello Hilary,
Thanks for your quick reply. This seems to be an interesting track.
Can you tell me how I can make the catalog accent sensitive?
Thanks again,
Pierre
Hilary Cotter wrote:
> By default IIRC SQL Server 2005 is accent insensitive whereas indexing
> services is not. You have the option of making your catalog accent
> sensitive.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <pierre.laduron@.thalesgroup.com> wrote in message
> news:1160492048.051686.161080@.i3g2000cwc.googlegro ups.com...
> When I use the "Indexing Service Query Form", searching documents for
> the word "Dsir", I get 50 matched records.
> If I run the following query from SQL-Server 2005 (on the same machine)
> :
> SELECT * FROM
> OPENQUERY
> (CVCATALOG,
> 'SELECT FILENAME, RANK FROM SCOPE()
> WHERE CONTAINS(''"dsir"'')
> ')
> I only get 45 results.
> This seems to be linked to the special characters () since it gives
> the same result if I specify a word without accents.
> Any idea?