views:

151

answers:

0

I am using SQL Server 2005 for full text searching. I did try the same create statement (with the same DB server collation //edit: Latin1_General_CI_AS) on SQL Server 2008 but it does not work anymore for umlauts:

create table "ArtistFullTextTest" ( 
    "ID" int IDENTITY(1,1) not null CONSTRAINT ArtistFullTextTest_PK PRIMARY KEY,
    "Name" nvarchar(150) not null
    )  
go

sp_fulltext_database 'enable'
GO

CREATE FULLTEXT Catalog ArtistFullTextTestCatalog AS DEFAULT
GO

-- 1031 is for german, did also try with 1033
CREATE FULLTEXT INDEX ON ArtistFullTextTest (Name LANGUAGE 1031)
KEY INDEX ArtistFullTextTest_PK 
GO

insert into ArtistFullTextTest values ('The Offspring')
insert into ArtistFullTextTest values ('Herbert Grönemeyer')

-- works in 2005+2008    
select * from ArtistFullTextTest where contains(Name, N' "offsp*" ') 

-- works in 2005+2008
select * from ArtistFullTextTest where contains(Name, N' "gr*" ')

-- works in 2005 - but NOT in 2008 - why?
select * from ArtistFullTextTest where contains(Name, N' "grö*" ')

Thanks in advance!