French characters on English Platform dropped

French characters on English Platform dropped

Post by Alexandre » Sat, 11 Sep 2004 20:54:00


Hi all,

I Had installed an english platform with full text indexing enable.
My data are French (with some accents for example).
When I search with a CONTAINS Statement on my Data, SQL Server drops my
accentuates characters.

How can I resolve this problem ?
What must I install on my platform to resolve this problem ?

Thanks for your answers.

Alex.
 
 
 

French characters on English Platform dropped

Post by Hilary Cot » Sun, 12 Sep 2004 00:02:27

Exactly what do you mean by this.

Do you mean that a search on cafe will not match with a search on the
accented version of cafe?

This problem is fixed in SQL 2005.

In the meantime you have to expand your search on both the accented and
unaccented version of the search term.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

 
 
 

French characters on English Platform dropped

Post by Alexandre » Tue, 14 Sep 2004 16:20:14

Hi,

No, I mean that my data are in french version and my full text search turn
on an English Platform.
When I search a french word, the fulltext search dropped my accented
characters so my search doesn't work.

Any Ideas ?

Thanks.
 
 
 

French characters on English Platform dropped

Post by John Kan » Wed, 15 Sep 2004 02:44:05

Alexandre,
This has been a long outstanding bug in SQL Server 7.0 and SQL Server 2000,
that is only "fixed" in SQL Server 2005 (Yukon) via the following new T-SQL
syntax:

CREATE FULLTEXT CATALOG Employee_FTC WITH ACCENT_SENSITIVITY = ON

CREATE FULLTEXT CATALOG Employee_FTC WITH ACCENT_SENSITIVITY=OFF

-- Or by using ALTER FULLTEXT CATALOG:

ALTER FULLTEXT CATALOG Employee_FTC REBUILD WITH ACCENT_SENSITIVITY=ON

The SQL Server 7.0 or SQL Server 2000 solution requires the duplication of
the accented data with the removal of accents via a UDF and insert/update
trigger to maintain the duplicate data. You would create a FT Index on the
non-accented data and return the accented data to your searcher.

Regards,
John










my