I need to create a full-text index on a table containing Czech text. However, upon submitting the create command i received this error:CREATE FULLTEXT INDEX ON dbo.TABLE (Code LANGUAGE Czech, DESC_CZ LANGUAGE Czech, DESC_EN LANGUAGE English, Code_Group LANGUAGE English) KEY INDEX TABLE_PK WITH change_tracking Manual
Msg 7696, Level 16, State 10, Line 2Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed.(When I try to create English index on all columns it works, so really just the Czech is the problem.)When i try to create the index using the wizard I don't get Czech in the dropdown list either.Result of the SELECT * FROM sys.fulltext_languages
doesnt give me Czech either.In sys.syslanguages, however, Czech does appear.Can anyone help me how to add the Czech Word Breaker? I found only how to add Polish, Danish and Turkish, but no link to a list of other third-party breakers or for that matter Microsoft-made breakers either.(All I found was that something similar to Czech word breaker was added do Office 2007 in SP2...)
Czech Word Breaker for Full-Text index
Posted - 2009-05-27 : 08:13:54
