Hi,
For case insensitive you must use the regexp search as follow :
SELECT title, firstname, lastname, description FROM stuff
WHERE title *~ '.*<keyword>.*' AND firtsname *~ '.*<keyword>.*';
>
> 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.
I don't know about windows-1251. Perhaps this can't help you. But if
you have japanese in you database, you can proceed a search on it so
why not windows-1251 ?
A+
Gilles
