Search

Greetings,

I store text data in windows-1251 encoding in my pgSQL database
and when I execute SQL command like

SELECT title, firstname, lastname, description FROM stuff
WHERE title LIKE '%<keyword>%' AND firtsname LIKE '%<keyword>%'
AND lastname LIKE '%<keyword>%' AND description LIKE '%<keyword>%'

the response comes really quick, but if I want case independent
search, I should convert, using my own PHP3 function, both search
field and keyword to low case just becouse PostgreSQL by itself
doesn't know how to convert characters in windows-1251 encoding
to low case. And response time grows from 0:07 to 1:10!

Is there any solution? May be stored procedures (that doesn't
require to recompile pgSQL)? Thank you in advance!!!

P.S.: as far as I know there is no locale for windows-1251 and,
unfortunately, I can't store data in koi8-r whose locale present
in almost all UNIX'es.

Mentioned above function:
function lower($str)
{
$length = strlen($str);

for ($i = 0; $i < $length; ++$i)
{
$sym = ord($str[$i]);
if (($sym > 34 && $sym < 60) || ($sym > 191 && $sym < 224))
$str[$i] = chr($sym + 32);
}

return $str;
}

--
BEST WISHES, Dmitry
Webmaster, DeltaCube Studio
http://www.deltacube.com/