Wednesday, March 28, 2012

Problem with Japanese Inflectional search

Hi,
We have Full Text enabled for five languages, four of them
are latin based and the other in Japanese.
We have built catalogs by specifying the respective
languages for word breakers.
Now the inflectional search is working fine for the latin
based languages but not working for Japanese.
Can anyone tell me if any settings needs to be changed to
make the Inflectional search work for Japanese?
Regards
Anand
Anand,
What is the SQL Server version (7.0 or 2000) and on what OS Platform (NT4.0,
WinXP, Win2000 or Win2003) is it installed on?
Could you post the full output of the following SQL script:
use <your_database_name>
go
SELECT @.@.language
SELECT @.@.version
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enabled_table_name_here>
sp_configure 'default full-text language'
go
Also, what is the default language setting for the server where SQL Server
is installed? Assuming the correct language settings and "Language for Word
Breaker", there should be nothing to change to make FORMSOF(Inflectional)
search work for your FT-enable table column that contains Japanese text.
Thanks,
John
"Anand" <anonymous@.discussions.microsoft.com> wrote in message
news:1b0d301c44f7e$cb917e40$a501280a@.phx.gbl...
> Hi,
> We have Full Text enabled for five languages, four of them
> are latin based and the other in Japanese.
> We have built catalogs by specifying the respective
> languages for word breakers.
> Now the inflectional search is working fine for the latin
> based languages but not working for Japanese.
> Can anyone tell me if any settings needs to be changed to
> make the Inflectional search work for Japanese?
> Regards
> Anand
>

No comments:

Post a Comment