By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,369 Members | 1,138 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,369 IT Pros & Developers. It's quick & easy.

Full-text search for Japanese characters

P: n/a
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
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.