Skip site navigation (1) Skip section navigation (2)

search engine php3 not case sensitive

From: Carlo Perassi <perassi(at)vlsilab01(dot)polito(dot)it>
To: pgsql-admin(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: search engine php3 not case sensitive
Date: 2000-01-30 08:45:42
Message-ID: 3893FA36.86990BC2@vlsilab01.polito.it (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-interfaces
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
--

pgsql-admin by date

Next:From: Ragnar KjørstadDate: 2000-01-30 11:41:36
Subject: Re: [ADMIN] request for tuning suggestions from PC Week Labs
Previous:From: Brad BonkoskiDate: 2000-01-30 07:43:18
Subject: pg_dump question...

pgsql-interfaces by date

Next:From: Ulf MehligDate: 2000-01-30 11:32:02
Subject: Re: [INTERFACES] multibyte-support
Previous:From: Tatsuo IshiiDate: 2000-01-30 00:46:24
Subject: Re: [INTERFACES] multibyte-support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group