June 18, 2003 at 10:00 am
Is full-text search case sensitive too if SQL Server is installed as case sensitive?
June 19, 2003 at 6:58 am
Don't know as my db's are case-insensitive anyway. However did find this snippet in BOL
Note The full-text search queries behave in a case-insensitive manner for those languages (mostly Latin-based) for which case sensitivity is meaningful. However, in Japanese, there are multiple phonetic orthographies in which the concept of orthographic normalization is akin to case insensitivity (for example, kana = insensitivity). This type of orthographic normalization is not supported.
doh!!!
Far away is close at hand in the images of elsewhere.
Anon.
June 19, 2003 at 12:26 pm
Hi Allen,
quote:
Is full-text search case sensitive too if SQL Server is installed as case sensitive?
I've never noticed case sensivity on full text search.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply