Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2009-05-13 : 17:37:59
|
| Hi AllIn my recent Application i had to store MS-Word Document in sql Server , i did it and till now there is no problem BUT i have one question ?I have used Image Field for storing Files in Sql2000 , now how i can give this opportunity to my end user to Search on above ms-word contents that are saved in image fields in SQL server?probably i can not do that But what's your idea?Thanks in advance.Kind Regards.Nothing is quite impossible! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-13 : 18:22:25
|
| Look at Full-text indexing and searching in Books Online. You can store Word documents in the database and have an indexing filter parse it for full-text queries. |
 |
|
|
ZarrinPour
Yak Posting Veteran
66 Posts |
Posted - 2009-05-14 : 11:58:50
|
quote:
Originally posted by robvolk
Look at Full-text indexing and searching in Books Online. You can store Word documents in the database and have an indexing filter parse it for full-text queries.
Thank you robvolk 4 ur reply.Excuse me for my ignorance,I don't know anything about Full-text indexing BUT As you know MS-Word files are binary files so Could you please tell me how sql can Search for some text through this Binary content in Image Fields?By the way Could you please show some Simple article about Full-text indexing Thanks in advance.Kind Regards.Nothing is quite impossible! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-14 : 12:51:57
|
| http://msdn.microsoft.com/en-us/library/ms142547.aspx -- for SQL 2008http://msdn.microsoft.com/en-us/library/aa172842(SQL.80).aspx -- for SQL 2000There are examples in the table of contents tree for that article.SQL Server 2008 natively supports full-text indexing and searching on the Word .doc format. I think SQL 2000 does too, you may have to install a filter for it. The filter handles the indexing of text from the binary data in the document. |
|
|
|
ZarrinPour
Yak Posting Veteran
66 Posts |
Posted - 2009-05-14 : 14:53:21
|
quote:
Originally posted by robvolkI think SQL 2000 does too, you may have to install a filter for it. The filter handles the indexing of text from the binary data in the document.
Thanks robvolk !Yes you are right, there is some filter for this , i found a useful article on How to enable full text Indexing on Image Fields;[url]http://www.sitepoint.com/blogs/2006/11/12/sql-server-full-text-search-protips-part-1-setup/[/url]Once again Thank you 4 ur helpNothing is quite impossible! |
|
|
|
|
|
|
Searching Image Fields Contents...?