Different result when using Indexing Service Query Form and SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pierre.laduron@thalesgroup.com - 10 Oct 2006 15:54 GMT

When I use the "Indexing Service Query Form", searching documents for
the word "Désiré", 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ésiré"'')
')
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?

Reply to this Message

Hilary Cotter - 10 Oct 2006 16:23 GMT

By default IIRC SQL Server 2005 is accent insensitive whereas indexing
services is not. You have the option of making your catalog accent
sensitive.

Signature

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

Reply to this Message

pierre.laduron@thalesgroup.com - 11 Oct 2006 10:10 GMT

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

> By default IIRC SQL Server 2005 is accent insensitive whereas indexing
> services is not. You have the option of making your catalog accent
[quoted text clipped - 28 lines]
> the same result if I specify a word without accents.
> Any idea?

Reply to this Message

Hilary Cotter - 11 Oct 2006 15:24 GMT

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','isaccentsensitive')

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','isaccentsensitive')

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','isaccentsensitive')

GO

select is_accent_sensitivity_on from sys.fulltext_catalogs where
name='testcatalog'

GO

Signature

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
[quoted text clipped - 30 lines]
> the same result if I specify a word without accents.
> Any idea?

Reply to this Message