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"ww"p"w',N'b"ww "p"w',N'b"ww"p"w')
(ran a full population)
2. select N'PageName' from tbSearch where FREETEXT(*,
N'b"ww"p"w')
3. select N'PageName' from tbproduct where CONTAINS(*,
N'b"ww"p"w')
I got "no result".
Please give me some ideas.
Thank you very much!
Tracey