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
>

problem with japanese character 俱

Hi All,

Create a table , and put in some row 子ど and 俱

and fire a query something like SELECT * FROM mytable WHERE (myColumn = '子ど')

it gives me right result.

But if i fire

SELECT * FROM mytable WHERE (myColumn = '俱')

It does not return any result for the same even if myColumn has '俱'.

Surprisnly if i fire query like "SELECT * FROM mytable" it

correctly dispalys 俱.

What's the reason for the same ? Why does it is not able to search me on this japanese character(俱).Collation is Japanese_Unicode_CI_AS

Regards,

Sunil

Hi Sunil,

you wil have to indicate that the string is unicode in your query:

SELECT * FROM mytable WHERE (myColumn = N'俱')

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks Jens for your quick response.

I have one query why it was working without N in 子ど but not in 俱

Regards,
Sunil

problem with japanese character 俱

Hi All,
Create a table , and put in some row Xど and 俱
and fire a query something like SELECT * FROM mytable WHERE
(myColumn = 'Xど')
it gives me right result.
But if i fire
SELECT * FROM mytable WHERE (myColumn = '俱')
It does not return any result for the same even if myColumn has '俱'.
Surprisnly if i fire query like "SELECT * FROM mytable" it
correctly dispalys 俱.
What's the reason for the same ? Why does it is not able to search me on
this japanese character(俱).Collation is Japanese_Unicode_CI_AS
Regards,
Sunil
Please don't multi-post. If you really need to post in multiple
newsgroups, you should cross-post (post only one time, but with both
newsgroups in the To: field).
I've responded to this question in the
microsoft.public.sqlserver.programming newsgroup.
Razvan