Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Full-text search for Japanese characters

0 views
Skip to first unread message

Tracey

unread,
Jul 22, 2003, 9:38:05 PM7/22/03
to
Hi there,

I want to search Japanese characters with Full Text search function. I
created a table (tbSearch) for Full-text search on SQL 2000, English
Win2k Server. The table contains 4 fields, which are ID -- int,
primary key, identity; PageName -- nvarchar; Contents -- ntext;
Keywords -- ntext.

Defined a Full Text index and Full Text catalog in the Full Text Index
Wizards and selected "Neutral" from "Language for Word Breaker", the
table fields to be indexed were PageName, Contents and Keywords, then
ran a full population.

I executed some SQL statements as follows:
1. insert into tbSearch
VAULES(N'çb"ÏëÂäwóùäwï"âûópê"äwâ»',N'çb"ÏëÂäwóùäwï"âûópê"äwâ»',N'çb"ÏëÂäwóùäwï"âûópê"äwâ»')
(ran a full population)

2. select N'PageName' from tbSearch where FREETEXT(*,
N'çb"ÏëÂäwóùäwï"âûópê"äwâ»')

3. select N'PageName' from tbproduct where CONTAINS(*,
N'çb"ÏëÂäwóùäwï"âûópê"äwâ»')

I got "no result".

Please give me some ideas.

Thank you very much!

Tracey

0 new messages