469,319 Members | 2,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

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"ì‘åŠ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
Jul 20 '05 #1
0 2436

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.