> > I'm not sure what you mean by "non-ASCII" text, however, I > > think that SQL Server supports Unicode full-text indexing > > out of the box, with no add-ons. > > PDF, Word documents, etc. Basically, binary file formats.
Well, in that case, SQL Server (and/or NTFS) is the product for you: "Indexes a variety of file formats, including Microsoft� Office 97, Microsoft� Office 2000, text files, and HTML pages... the full-text indexing engine used by Windows 2000 is compatible with full-text indexing features of Microsoft� SQL Server(tm) version 7.0 (and 2000). By using the distributed query processor in SQL Server, you can specify queries using structured query language (SQL) and execute them simultaneously against the file system and a database." Paul Hastings (on this list) is a big fan of the SQL Server full-text indexing. I still prefer Verity, myself, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
