SQL 2000 with full-text and accent insensitive

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL 2000 with full-text and accent insensitive

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-01 : 10:17:11

jan willem writes "Hi, I am using SQL Server 2000, Windows 2000 and have the collation for my database set to SQL_Latin1_General_CP850_CI_AI. I would like to search text data that contains accented words but I want my search to be accent insensitive. With my database collation set as above, using the "LIKE" keyword accomplishes what I desire. However, I would like to use full-text searching and the accent insensitive collation does not apply.
Has anyone had any luck with this? Is there a way to cast the full-text search predicate to a specific collation?

I've included a sample script.

Thanks, Jan Willem

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Test]
GO

CREATE TABLE [dbo].[Test] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[file1] [char] (10) COLLATE Latin1_General_CI_AI NULL ,
[title] [text] COLLATE Latin1_General_CI_AI NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Test] WITH NOCHECK ADD
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO

if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) <> 1
exec sp_fulltext_database N'enable'
GO

if not exists (select * from dbo.sysfulltextcatalogs where name = N'test')
exec sp_fulltext_catalog N'test', N'create'

GO
exec sp_fulltext_table N'[dbo].[Test]', N'create', N'test', N'PK_Test'
GO
exec sp_fulltext_column N'[dbo].[Test]', N'title', N'add', 1036
GO
exec sp_fulltext_table N'[dbo].[Test]', N'activate'
GO

insert into test (file1, title)
values (1, 'europeenne')

insert into test (file1, title)
values (1, 'européenne')

"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources