I'm trying to get my full text search (in boolean mode) to retrieve words with three letters or less. Currently, if I search for something like "NBA", I don't get any results. However, if I append the wild card operator "*" to the search term, I get results. I also read that you could remove the three word limit in my.ini, but I'm won...
I'm trying to use ContainsTable to return a ranked list of results. I have it working fine when it finds a whole word match but its doesnt seem to work for partial words. For example if I search for 'acq' it wont find 'Acquisitions'. I really need it to work with partial matches for it to be useful. Using "Like" is not an option as the...
I have a table (table 1) with couple of column on which i want indexed. There is also ArticleID column (foreign key), with this id I want to use join to retrieve "articleTitle" from the article Table (table 2), and of curse be able to search in this column. How do I create this kind of index? Do I need to index both tables? and how shou...
I want to use SQL SERVER 2008 Full text search to get the records that have a word or a phrase as the whole text within the field and not as part of the text within the field. For example: I have many records containing the Word 'Inheritance' as the whole text in the field and other fields containing the same word in between,at the begin...
I'm using Lucene.Net to create a website to search books, articles, etc, stored as PDFs. I need to be able to filter my search results based on author name, for example. Can this be done with just Lucene? Or do I need a DB to store the filter fields for each document? Also, what's the best way to index my documents? I'll have about 5...
I'd like to make MySQL full text search work with Japanese and Chinese text, as well as any other language. The problem is that these languages and probably others do not normally have white space between words. Search is not useful when you must type the same sentence as is in the text. I can not just put a space between every charact...
I want to search product information using Full Text Search, I have used six table in search query but i faced below issue I want to use full text search in SQL Server 2005. So I am facing the problems which is as below. 1) I am using 6 tables. i) Product (ProductID primary key,Name,Description,Summary,ImageFileNameOverride) ii) M...
I have an application that generates around 10000 printed pages per month. Each report (around 2000/month) is archived as PDF on a simple network file share. I am searching for a Document Management System meeting the following requirements: watch the archive folder and update the index either on regular basis or when changes are dete...
Are there any open source or commercial tools available that allow for text fragment indexing of database contents and can be queried from Java? Background of the question is a large MySQL database table with several hundred thousand records, containing several VARCHAR columns. In these columns people would like to search for fragments ...
Hi! I am first day with SOLR, and of course, i have some problems with it. I need to index a database, which is postgresql database. I defined fields in data-config.xml file, added DataImportHandler to solrconfig.xml, added postgresql jar to solr folder. But, when i am starting SOLR, i have the following error: 2009-10-27 16:08:53.28...
I'm looking for answers for the following 2 questions (SQL Server 2000). I have an order info table that is indexed so that I may search data on particular columns. So, an example query I might run is: SELECT top 50 ft_tbl.*, key_tbl.Rank from OrderInfo as ft_tbl INNER JOIN FREETEXTTABLE(OrderInfo, Address1, 'W Main St') as key_tbl ...
Can somebody please, let me know that how do we find that full text search is enabled in SQL 2005. ...
I need to create a full-text search form for a database of emails / support tickets (in C#) and I'm looking for advice and articles on how to approach this. In particular I'd like to know how to approach the classic full-text search problems, for example: Making sure that matches are sensible, for example if someone enters "big head" ...
I have a postgresql database. In table, which i need to index, i have about 20 million rows. When i want to index them all in one attempt(smth like "select * from table_name"), i have Java OutOfMemory error, even, if i`ll give to JVM more memory. Is there any option in SOLR to index a table part by part(e.g. execute sql for first 10000...
I'm writing an SQL data updater to convert old text/ntext/image type columns into varchar/nvarchar/varbinary. The updaters are run within transactions when the system boots to update the database from an older version. I've gotten the SQL to work on its own, but a handful of the columns being changed were full-text indexed, which means I...
Eventually, I'm creating a website on three languages: english, russian and chinese. I hope that if I use UTF-8 in application and database, there won't be any problems with input-output (will there?) But the most frightening part of it is a search. It should be cool enough. It should be full-text, it should index, etc. I hope it will u...
I'm using Lucene.Net to implement a search website (to search PDFs). Once the keyword is entered, I display the results, and when one of the result items is clicked, I want to take the user to a "details" page, where I want to display snippets from that PDF document everywhere the keyword is found. So my question is, what's the best way...
Hi folks, i have a field that contains guid's. They represent a user's PunkBuster GUID. Is it possible to create an index, on this field, which only index's the last 8 characters of the guid? The reason i'm asking is that you cannot to a full text search like => '*abcdef'. (at least I believe I read that somewhere ... was it Pro Full-...
I have a reasonably large number of text documents ( 400+ ) which contain speeches related to an organization that I am a member of. We would like to distribute a CD/DVD which contains all these speeches along with an application that allows one to search based on keyword and find speeches which are relevant to that topic. My question i...
Hi, in SQL Server 2008, when setting up a full text search, it gives me an option to choose a time/day for it to re-populate the index, can I do this from code instead like C# code? if so how would I do it? Would I need to execute SQL code from C# to refresh the index? Also, say if I DONT re-populate the index and add some new records,...