Arshavir,
> Thanks for all the replies. It actually has to do with the locales. The
> db where the index gets used is running on C vs the the other one that
> uses en_US.UTF-8. I guess the db with the wrong locale will need to be
> waxed and recreated with correct locale settings. I wonder if there are
> any plans to make LIKE work with all locales.
I thought there were some fixes for this in 8.0, but I can't find anything in
the release notes.
--
Josh Berkus
Aglio Database Solutions
San Francisco