Focus on Code

As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :


word1,word2,word3



word1|word2|word3


In these cases you cannot not find what you’re searching may be. Because database engine thinks that there’s no white spaces in this so this can be word.

So what we do?

We just add white spaces at the end of words like this :


word1 word2 word3


Don’t worry about two char or three char words. Always there can be option in database engine that limits minumum char length on full-text searches.

Tags: advantage, advantage local server, database, errors, solutions, sql

This entry was posted on Tuesday, June 19th, 2007 at 5:01 am and is filed under advantage.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.