"Tracey" <traceycui332@hotmail.com> wrote in message
news:10dafa66.0307271623.2e3f9ae4@posting.google.com...
> Hi John,
>
> Thanks for your reply.
>
> I Have changed 'Neutral' to 'Japanese' from "language for Word
> Breaker". And it is still not working properly, like, some results are
> not related to search string. But,if I use 'like' instead of
> 'FREETEXT', I get all correct results. The SQL statement is:
> select * from tbSearch where PageName like N'b"ì'åSw-Sw."?z-p"Sw?È'
> ?
>
> The default language is 'en_english'(select @@language), unfortunately
> I can not change the setting.
>
> Do I need to change any settings to make the Full-text search function
> working?
>
> Regards,
>
> Tracey
>
>
> "John Kane" <jt-kane@comcast.net> wrote in message
news:<uDlyWqXUDHA.3312@tk2msftngp13.phx.gbl>...
> > Tracey,
> > Why did you select "Neutral" from "Language for Word Breaker" when
Japanese
> > is a valid option?
> > The use "Neutral" for Language for Word Breaker, causes the words to be
> > broken based upon the "white spaces" between words and this is not what
you
> > want to use, if the only language in your FT Index columns.
> >
> > I'd recommend that you drop and re-create your FT Catalog and re-create
it
> > with "Japanese" for the Language for Word Breaker and then run a Full
> > Population and re-test your query. There may be other issues here as
well,
> > such as changes to the MSSQLServer startup account from the Component
> > Services, but lets get the language for word breaker set to the correct
> > language first.
> >
> > Regards,
> > John
> >
> >
> >
> > "Tracey" <traceycui332@hotmail.com> wrote in message
> > news:10dafa66.0307231548.42b7973e@posting.google.com...
> > > Hi there,
> > >
> > > I want to search Japanese characters with Full Text search function. I
> > > created a new database on SQL 2000, English Win2k Server. The
> > > database's collation is "Japanese-bin" and contains one table that
> > > 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"ì'åSw-Sw."?z-p"Sw?È',N'b"ì'åSw-Sw."?z-p"Sw?È',N'b"ì'åSw-S
> > w."?z-p"Sw?È')
> > > (ran a full population)
> > >
> > > 2. select N'PageName' from tbSearch where
> > > FREETEXT(*,N'b"ì'åSw-Sw."?z-p"Sw?È')
> > >
> > > 3. select N'PageName' from tbproduct where
> > > CONTAINS(*,N'b"ì'åSw-Sw."?z-p"Sw?È')
> > >
> > > I got "no result" from point 2 and 3.
> > >
> > > Please give me some ideas.
> > >
> > > Thank you very much!
> > >
> > > Tracey