From: Carlo Perassi <perassi@vlsilab01.polito.it>
To: pgsql-admin@postgresql.org
To: pgsql-interfaces@postgresql.org
Subject: search engine php3 not case sensitive
Date: Sun, 30 Jan 2000 08:45:42 +0000
Message-ID: <3893FA36.86990BC2@vlsilab01.polito.it> (raw)
hi all
I hope this is not a trivial question... I haven't find any answer on
the FAQ anyway...
I'm developing a little search engine (PostgreSQL+Apache+PHP3) working
wiht long fields (like 8000 char)
if someone insert the word
<word>
into my form I can search for:
<word> "as is"
Word
WORD
word
If someone would search for a chemical formula I should provide the
right output without any dependencies with the upper case or lower case
used by the client...
for example if you write
nacl
I should be able to search for
<nacl> "as is"
Nacl
NACL
Nacl
BUT most of all for NaCl, the right one!
Real search engine like Altavista to that of course... I don't assume I
want to develop something like Altavista, for sure ;P, but a little hand
could be appreciated anyway.
thanks.
ps: by the way... the php3 function soundex probably it's not the last
answer on that problem.
--
Carlo Perassi
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: perassi@vlsilab01.polito.it, pgsql-admin@postgresql.org
Subject: Re: search engine php3 not case sensitive
In-Reply-To: <3893FA36.86990BC2@vlsilab01.polito.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox