Locale ID

Is missing.. Any suggestions
More Info here .
Using SQL 2005.. Trying something like this :
Select * from myTable where freetext(*,'Drive',Language 1030) -- Lang.
Danish
Error saying that Locale ID is invalid. Every other language I've tried is
working.. Anybody ?
Regards
Bobby Henningsen
"Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
news:eJrjYs70FHA.1028@.TK2MSFTNGP12.phx.gbl...
> Is missing.. Any suggestions
>
|||Bobby,
What is the exact version of SQL Server 2005 (@.@.version) that you are using?
Danish is a supported FTS language in the June CTP Yukon version:
select * from sys.fulltext_languages
/* -- returns (23 row(s) affected)
lcid name
-- ---
2052 Simplified Chinese
1028 Traditional Chinese
1030 Danish
....
*/
Try the following
select * from myTable -- use contains vs. freetext
where contains(*,'formsof(inflectional,"danish_word")',l anguage 1030)
Also, when you created the fulltext index, did you define Danish as the
"Language for Word Breaker"? Is there a mix of languages in this column, if
so what did you use to define the "Language for Word Breaker"?
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
news:uSXrxE80FHA.1040@.TK2MSFTNGP14.phx.gbl...
> More Info here .
> Using SQL 2005.. Trying something like this :
> Select * from myTable where freetext(*,'Drive',Language 1030) -- Lang.
> Danish
> Error saying that Locale ID is invalid. Every other language I've tried is
> working.. Anybody ?
> Regards
> Bobby Henningsen
>
> "Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
> news:eJrjYs70FHA.1028@.TK2MSFTNGP12.phx.gbl...
>
|||Im using the September CTP 9.0.1314. I've already checked the
master..syslanguages and "danish" is there. I've installed it on 2 different
machines and I get the same error. Installing the june CTP again and it
works fine. The locale ID 1029 isn't working either. I can't change the
"Language for Word Breaker" to danish, because it isn't in the list!! using
"Contains" gives me the exact same error. So for me it looks like the
ressouce isn't installed so the big question is : How do I do that ?
Regards .)
Bobby Henningsen
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eSdxro$0FHA.3376@.TK2MSFTNGP14.phx.gbl...
> Bobby,
> What is the exact version of SQL Server 2005 (@.@.version) that you are
> using?
> Danish is a supported FTS language in the June CTP Yukon version:
> select * from sys.fulltext_languages
> /* -- returns (23 row(s) affected)
> lcid name
> -- ---
> 2052 Simplified Chinese
> 1028 Traditional Chinese
> 1030 Danish
> ...
> */
> Try the following
> select * from myTable -- use contains vs. freetext
> where contains(*,'formsof(inflectional,"danish_word")',l anguage 1030)
> Also, when you created the fulltext index, did you define Danish as the
> "Language for Word Breaker"? Is there a mix of languages in this column,
> if so what did you use to define the "Language for Word Breaker"?
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Bobby Henningsen" <bobhen@.tiscali.dk> wrote in message
> news:uSXrxE80FHA.1040@.TK2MSFTNGP14.phx.gbl...
>