471,854 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,854 software developers and data experts.

Full-text search for Japanese characters

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
0 2579

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by daking | last post: by
reply views Thread by reneecccwest | last post: by
7 posts views Thread by alexcn | last post: by
2 posts views Thread by Larry R Harrison Jr | last post: by
2 posts views Thread by Lee | last post: by
11 posts views Thread by rh00667 | last post: by
5 posts views Thread by =?Utf-8?B?TWFydHluIEZld3RyZWxs?= | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.