Re: Accent-sensitive
From: Hilary Cotter (hilaryk_at_att.net)
Date: 05/25/04
- Next message: Hilary Cotter: "Re: Accent-sensitive"
- Previous message: mike: "display properties"
- In reply to: Syl20: "RE: Accent-sensitive"
- Next in thread: Syl20: "RE: Accent-sensitive"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 May 2004 19:00:38 -0400
Accent sensitive means that when I query on cafe, in a table like this
select * from TableName where col1='cafe' I will not get rows returned to
the accented version of cafe.
Accent insensitive means that I will.
With SQL FTS, the tokens found in your columns you are full text indexing
are stored as unicode, so a cafe is a different unicode sequence than the
accented version of cafe.
You can select how SQL Server treats accents, but not MSSearch, which is the
engine which does your searching in SQLFTS.
So to be totally correct - SQL FTS is accent sensitive or not accent
insensitive. Thanks for the correction.
"Syl20" <anonymous@discussions.microsoft.com> wrote in message
news:88DDAA02-A424-4FE4-9E3A-F797ED2D543B@microsoft.com...
> I Think you want to say the SQL FTS is not Accent Insensitive. If it was
Accent Insensitive, Marco would have no problem !
- Next message: Hilary Cotter: "Re: Accent-sensitive"
- Previous message: mike: "display properties"
- In reply to: Syl20: "RE: Accent-sensitive"
- Next in thread: Syl20: "RE: Accent-sensitive"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
