Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
1 answer

Handling Full Text Permutations SQL Server

We have a database table that holds a list of countries and basic information about them, that we use Full Text Indexing to return data to the user through a web app. I am looking into country names and the different permutations (spellings) that…
Isaac Levin
  • 2,809
  • 9
  • 49
  • 88
0
votes
2 answers

"Query is not understandable" - Full text searching where field types have changed

A client have a long lived IBM Notes application where someone along the line changed the type of a field from number to text. So, now when we're trying to do an FT search like: [myField] = "1234" receive the error message: "Query is not…
jBoive
  • 1,219
  • 1
  • 14
  • 40
0
votes
2 answers

Lucene.NET on shared hosting

I'm trying to get Lucene.NET to work on a shared hosting environment. Mascix over on codeproject outlines here how he got this to work on godaddy. I'm attempting this on isqsolutions. Both examples he posted run fine on my local machine and both…
Andrew Grothe
  • 2,562
  • 1
  • 32
  • 48
0
votes
0 answers

"Warning Master Merge operation was not done..." What to do?

Have anyone encountered this error message in the SQL server log? Warning Master Merge operation was not done for dbid 56, objid 286624064, so querying index will be slow. Please run alter fulltext catalog reorganize. No other errors are…
ddragostinov
  • 68
  • 7
0
votes
1 answer

Does a Full-Text Index work well for columns with embedded code values

Using SQL Server 2012, I've got a table that currently has several hundred-thousand rows, and will grow. In this table, I've got a nvarchar(30) field that contains Medical Record Number (MRN) values. These values can be just about any alphanumeric…
scott-pascoe
  • 1,463
  • 1
  • 13
  • 31
0
votes
1 answer

SQL Server : full-text search with join

This is probably something very basic. I'm brand new to full-text indexing and searches and I've been trying to get this to work for hours so please go easy on me :) Say I have a table of people with firstname, lastname,…
Four_0h_Three
  • 592
  • 10
  • 27
0
votes
2 answers

SqlException was unhandled by user code. (Full-Text index)

I am using vs 2012 Professional and SQL-Server 2012 Express. I was trying to run Admin.aspx, that has a textbox to search for users in a db. However, each time I try to search for a username I get this error Cannot use a CONTAINS or FREETEXT…
Brian
  • 1,951
  • 16
  • 56
  • 101
0
votes
3 answers

Lucene prohibited clause "fuzzyfied" where it shouldn't

I'm writing a filter based on Lucene: I have some results from an API and I would like to enforce the results to match a certain query (the API sometimes doesn't work). As the results are gotten from an API, I basically store them in RAM, index it,…
Ivan
  • 980
  • 7
  • 11
0
votes
1 answer

Is really necessary to have two fulltext indexes for text columns?

I inherited the codebase for a custom CMS built with MySQL and PHP which uses fulltext indexes to search in content (text) fields. When analyzing the database structure I found that all relevant tables were created in the following fashion…
Proteo
  • 11
  • 4
0
votes
1 answer

Which tool is better for storing html enabled text (closed email system)?

So my case is a closed email system. The emails are HTML enabled. What is needed: Full text searching (there are over 1 million emails in database, but they are usually pre-filtered based on users active in recent time) Archiving - How can I…
StanM
  • 827
  • 4
  • 12
  • 33
0
votes
1 answer

FullTextIndex in NexusDB, How to tokenize the searchstring

We are using NexusDB for a small database. We have a table with a FulltextIndex defined on it. The index is configured with the following options: Character separator ccPunctuationDash ccPunctuationOther The user enters a search text in an edit…
Bascy
  • 2,017
  • 1
  • 21
  • 46
0
votes
1 answer

Choose an appropriate language for full text index in SQL server

I want to add a column with Hungarian language to my table, and I want to full-text-index it. The problem is that SQL Server doesn't have Hungarian language registered, and I can't find any good tip by Microsoft about what's the best language to…
slallum
  • 2,161
  • 4
  • 24
  • 24
0
votes
1 answer

Suggestions for Searching Document Content- Is Windows Search Any Good? Simple MySQL?

I am writing a web script for a small online documents management company that wants to allow users to quickly search the content of their files online. While many accounts are very small (under 100 2MB files), there's a handful that have 1,000,000…
SilentSteel
  • 2,344
  • 1
  • 28
  • 28
0
votes
1 answer

full text indexing only returns 2 rows

I have a table for food and hotels like CREATE TABLE `food_master` ( `id` int(6) unsigned NOT NULL auto_increment, `caption` varchar(255) default NULL, `category` varchar(10) default NULL, `subcategory` varchar(10) default NULL, `hotel`…
arjuncc
  • 3,227
  • 5
  • 42
  • 77
0
votes
1 answer

PHP: convert mysql code so it will work with innodb?

I have migrated from myisam to innodb and i had to remove fulltext indexes from tables. now some parts of my script doesn't work, how can i convert the below code so it will work with innodb? $posts_fields = "SELECT SQL_CALC_FOUND_ROWS id, autor, "…
Crazy_Bash
  • 1,755
  • 10
  • 26
  • 38
1 2 3
…
37
38