Re: incorrect query reults

From: John Kane (jt-kane_at_comcast.net)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 11:46:46 -0800

You're welcome, Gerald,
I too searched the oenorm_example.txt file and found no hit on oenorm. While
asking for the @@version info is a start, sometimes for these more difficult
cases, I've most often ask for additional info as the different results may
be because of the language and possibly not using the correct "Language for
Word Breaker". Could you post the output from the following SQL code?

use <your_database_name_here>
go
SELECT @@language
-- may need to set show advanced options
sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

Depending upon the "Language for Word Breaker" that you are using along with
German text, this may explain the differences in results.

Thanks,
John

"Gerald Baeck" <GeraldBaeck@discussions.microsoft.com> wrote in message
news:98593AF6-6E55-4B6C-BEAC-5863743453A9@microsoft.com...
> Hi John,
>
> First of all thanks for your patient help!-)
>
> I checked all the rows manually and i am sure that there is no string like
> 'oenorm'. You can have a look at this File
> http://www.webwatch.at/oenorm_example.txt.
>
> The data is stored in plain text and contains no html-tags.
>
> The language of the text-field is german.
>
> regards, Gerald.
>
> "John Kane" wrote:
>
> > Thanks, Gerald,
> > Could you proved the exact text from a few of the rows that contain the
> > string 'oenorm', including all punctuation characters?
> > Is this HTML code or plain text that is stored in a text or varchar
column?
> > Also, what is the language of the text stored in the column?
> >
> > All of these factors, when considered with the OS platform (in your case
> > Win2K) can affect the results from the CONTAINS query.
> >
> > Regards,
> > John
> >
> >
> >
> > "Gerald Baeck" <exc3ktest@hotmail.com> wrote in message
> > news:ac510211.0411152308.3ec64f25@posting.google.com...
> > > John,
> > >
> > > its the other way round. The CONTAINS-Query returns many rows and the
> > > LIKE-Query does not. The LIKE-QUery return the correct resultset in
> > > that case.
> > >
> > > thx, Gerald.
> > >
> > >
> > > "John Kane" <jt-kane@comcast.net> wrote in message
> > news:<OtWs$f1yEHA.3656@TK2MSFTNGP09.phx.gbl>...
> > > > Gerald,
> > > > Why would you expect contains(text, ' "oenorm*" ') to return results
> > when
> > > > using text like '%oenorm%' does not return results?
> > > > While often the T-SQL LIKE will return different results when
compared
> > to
> > > > CONTAINS or FREETEXT, but if T-SQL LIKE cannot find it with it's
> > "pattern
> > > > matching" method and using leading and trailing wildcards (%), then
most
> > > > likely CONTAINS or FREETEXT will not return results as well as the
> > search
> > > > string is most likely not in your column: text.
> > > >
> > > > Regards,
> > > > John
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Gerald Baeck" <GeraldBaeck@discussions.microsoft.com> wrote in
message
> > > > news:418794BC-8ED0-4B72-9CC7-0AF3C50C04F5@microsoft.com...
> > > > > I forgot to tell, that the query
> > > > >
> > > > > select id, url from queue_suchsourceindex
> > > > > where text like '%oenorm%'
> > > > >
> > > > > returns no rows, as it should.
> > > > >
> > > > > thx, Gerald.
> > > > >
> > > > >
> > > > > "Gerald Baeck" schrieb:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > another problem occured!-)
> > > > > >
> > > > > > I did the following SQL-query:
> > > > > >
> > > > > >
> > > > > > select * from queue_suchsourceindex
> > > > > > where contains(text, ' "oenorm*" ')
> > > > > >
> > > > > > But in the result there are many rows, that do not contain the
word
> > > > "oenorm"
> > > > > > in its text field. First i thought i mixed somethiong up in
> > Application,
> > > > but
> > > > > > everything is working right there. Just the query return the
wrong
> > > > results.
> > > > > >
> > > > > > I have no clue, how to find out what the problem is.
> > > > > >
> > > > > > thx in advance, Gerald.
> > > > > >
> > > > > > my configuration:
> > > > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
> > 14:22:05
> > > > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on
> > > > Windows
> > > > > > NT 5.0 (Build 2195: Service Pack 4)
> > > > > >
> > > > > >
> >
> >
> >

Relevant Pages

  • Re: incorrect query reults
    ... You're welcome, Gerald, ... OENORM is not a true German word. ... you can switch to the Neutral "Language for Word Breaker" via dropping ...
    (microsoft.public.sqlserver.fulltext)
  • Re: incorrect query reults
    ... No rowguidcol column defined. ... > be because of the language and possibly not using the correct "Language for ... >> Hi John, ... >> regards, Gerald. ...
    (microsoft.public.sqlserver.fulltext)
  • When you can measure you can know
    ... Gerald L. O'Barr had some comments lately about math vs physics as if the ... later were the same as the former since the former is the language of the ...
    (sci.physics.relativity)
  • Re: For assembly, C# or VB or C++ ?
    ... Thanks millions, Daniel and Gerald. ... I guess no language is superior to others. ... I was assumed that C# was better for the managed code, ... > Each language has some differences, but they all compile to pretty much the ...
    (microsoft.public.dotnet.general)
  • Re: Is integer division always truncated
    ... Cor Ligthert wrote: ... As the OP hasn't specified what language they're using, ... C++, Gerald has assumed VB.NET.) ... If replying to the group, please do not mail me too ...
    (microsoft.public.dotnet.general)