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!