Indexing text within pdf content as a text file

Hello everyone,
I have a very strange problem : I've installed SQL server 2005, create
a storage for full index and full text index on a table. I've also
installed Adobe IFilter. Searches are OK but only on one criteria I
have problem. let me explain.
I'm searching in files in database for "c#" and some pdf files returned
by search are not containing "c#". Opening these PDF files with notepad
and searching for string "c#" let me find out why this file is returned
by search... Is it really the problem or not ? (is seems to do the same
on word files too...)
Thanks for your help.
Regards,
Ben.
SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the C in
your searches and content for this to work correctly.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<benjamin.soulier@.gmail.com> wrote in message
news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
> Hello everyone,
> I have a very strange problem : I've installed SQL server 2005, create
> a storage for full index and full text index on a table. I've also
> installed Adobe IFilter. Searches are OK but only on one criteria I
> have problem. let me explain.
> I'm searching in files in database for "c#" and some pdf files returned
> by search are not containing "c#". Opening these PDF files with notepad
> and searching for string "c#" let me find out why this file is returned
> by search... Is it really the problem or not ? (is seems to do the same
> on word files too...)
> Thanks for your help.
> Regards,
> Ben.
>
|||Hello Hilary,
Thanks for your quick answer, but it seems that the problem still
remains : I was wondering if it has something to do with the full text
index in database, as I configured it to case insensitive.
Do I have to put it back to case sensitive to make it work ?
Do I have to change noise words files (I've already removed "C" letter
from neutral and english files) ?.
Hilary Cotter a crit :[vbcol=seagreen]
> SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the Cin
> your searches and content for this to work correctly.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <benjamin.soulier@.gmail.com> wrote in message
> news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
|||I tried to do a test for myself on this :
I created a new table, with full text index in case sensitive mode,
adding documents to it.
I still get files not containing C# values (all types of documents).
I even tried to use CONTAINSTABLE and FREETEXTTABLE, but problem is the
same...
Any ideas ?
benjamin.soulier@.gmail.com a crit :[vbcol=seagreen]
> Hello Hilary,
> Thanks for your quick answer, but it seems that the problem still
> remains : I was wondering if it has something to do with the full text
> index in database, as I configured it to case insensitive.
> Do I have to put it back to case sensitive to make it work ?
> Do I have to change noise words files (I've already removed "C" letter
> from neutral and english files) ?.
> Hilary Cotter a crit :
|||I take it you are Swiss and using the German or French (or Italian) word
breakers. In these languages c# and C# are indexed as c and C# - a search on
c# or C# will match with c and c# (lower and upper case). English
unfortunately is the exception here. c# is indexed as c, and C# is indexed
as C#, the search is done on C# which will match with C# and a search on c#
will match with c.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<benjamin.soulier@.gmail.com> wrote in message
news:1169542818.105342.131360@.a75g2000cwd.googlegr oups.com...
Hello Hilary,
Thanks for your quick answer, but it seems that the problem still
remains : I was wondering if it has something to do with the full text
index in database, as I configured it to case insensitive.
Do I have to put it back to case sensitive to make it work ?
Do I have to change noise words files (I've already removed "C" letter
from neutral and english files) ?.
Hilary Cotter a crit :[vbcol=seagreen]
> SQL FTS interprets C# as C#, but c# as c. So you need to capitalize the C
> in
> your searches and content for this to work correctly.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <benjamin.soulier@.gmail.com> wrote in message
> news:1169490279.707200.130060@.a75g2000cwd.googlegr oups.com...
|||Hello,
I need to implement full text search with in PDF and Text files along with tables in sql server 2000 , I think you have done some simimlar things ,
Can you give me detail s on how i can achieve same .
Thanks for your help in advance
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Indexing And Physical Storage Of Data

1> How is the data stored physically when there is now primary key as well as any index defined in the table.....?
2> How is the data stored physically when there is just a primary key defined in one of the column of the table? No INDEX defined.
Thanks,
Rahul JhaHi Rahul

As per Tom's answer in the last thread again you need to read up on this subject. You can't get an understanding of indexes by asking questions like this on a forum - or at least not without asking hundreds of questions.

Read up on this and you'll learn that indexes <> primary keys but SQL Server (and most RDMSs) enforce primary keys through unique, non-null indexes. As such, senario 2 is impossible. Also - a primary key does not determine the physical characteristics of a table. The nature of (or lack of) the indexes does.