Having problems with space characters in search

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Everyone,

I'm facing a real problem using freetext seach. Whenever the recods
cointain spelling variations just on white spaces, I do not get the
desired results.

For example, when I search for "C Sharp" I'll get the propper
results.
However, when I try to search 'Csharp' (without a whitespace) I'll get
a result.

Example:

SELECT ProgLanguages
FROM Developers
WHERE CONTAINS(ProgLanguages, 'Csharp')

[ProgLanguages]
VB, SQL, CSHARP, Java --> Hit
VB, SQL, C SHARP, Java --> No Hit

I already modified the noise list and removed all characters. This
didn't help.

Is there anything that I'm missing? Has someone an idea?
Thank's in advanve!
Bernie

.

Relevant Pages

  • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
    ... Perl was to relate it to uninitialized values in Java or C++. ... The fact that nulls in SQL have special ... Both Java and C++ have containers that support set theoretic ...
    (comp.lang.perl.misc)
  • Re: SQL
    ... Persistence access is the abstraction, ... However, UML is just one of many OOA/D notations proposed, so it is an implementation of an OOA/D notation. ... Note that I was careful to say that SQL is a solution to persistence /access/ when the data is represented in RDB form. ... Sounds a little bit like Java and the JVM.... ...
    (comp.object)
  • Re: object databases
    ... Calling SQL from say java code is one of the easiest tasks in mordern ... The major problem is that SQL statements are written as strings in ... the strings are not compiled until runtime. ...
    (comp.object)
  • Re: Is perl better? :(((
    ... draw from variable "table" and execute a slightly modified SQL just once. ... > public void openCon(String url, ... > String user, String password) { ... > Total Java expenses 4.5 minutes. ...
    (comp.lang.java.programmer)
  • Re: Quote from student, after teaching Pick
    ... Standford) was "that is NOT a database." ... I had some success leading UniData customers to SQL, ... PHP and Java IIRC. ...
    (comp.databases.pick)