|
|
Non-noise words are incorrectly recognised as noise words. |
|
Author |
Message |
BestIndian
|
Posted: Tue Aug 23 08:34:16 CDT 2005 |
Top |
SQL Server Developer >> Non-noise words are incorrectly recognised as noise words.
Hi.
I have an Sql server 2005 beta2 problem with the full-text index
functionality.
I have a table with a full text index. In the definition of the full-text
index, I have specified the neutral language. The problem domain specifies
that texts can be in arbitrary languages.
create fulltext index on mytable
(
myfield language 0x0
)
...
Then I insert a record containing the word "and" (which in Danish means
duck). When searching for that record
select * from mytable where contains(myfield, 'and')
nothing is returned, and I get the message,"Informational: The full-text
search condition contained noise word(s)."
Apperantly, it uses the noise-word list for english, when I insert records
and search on that field.
I thought that when I specify the language as 0x0, the full-text index
should be language neutral and that would mean that it doesn't filter out
noise words(because those are language specific). Am I mistaken, or is it an
Sql Server 2005 beta2 bug?
Thanks in advance,
Peter Strøiman
SQL Server267
|
|
|
|
|
Aaron
|
Posted: Tue Aug 23 08:34:16 CDT 2005 |
Top |
SQL Server Developer >> Non-noise words are incorrectly recognised as noise words.
> I have an Sql server 2005 beta2 problem with the full-text index
> functionality.
Please post to the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
|
|
|
|
|
v-sguo
|
Posted: Tue Aug 23 20:23:35 CDT 2005 |
Top |
SQL Server Developer >> Non-noise words are incorrectly recognised as noise words.
Hello,
For questions of SQL server 2005, please post at the following newsgroup:
Welcome to the Microsoft SQL Server 2005 Community Technology (CTP)
Newsgroups
<http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&s
lcid=us>
Thanks for cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|
|
|