Hi, I know this could be a duplicate entry but I still haven't found a solution.

I Have to manipulate two Postgre database system, one of them has latin1 ecoding and the other one is utf8 drupal database.
I'm developing a search system with some special features (i'm indexing cck fields for a custom search trying to be high performancing oops).
The problem is that I can't make sql queries with special characters like accents cause of client enconding (I guess).

I would like to know if someone knows how to solve this problem or how to fix de client enconding from drupal code. Thanks a lot!!

(excuse my awful english) Thank you

Comments

carmelhm’s picture

carmelhm commented

I've discovered that taking off the "LOWER" function from the sql query solves parcially the main problem, but I still need a better way to do the search

dpearcefl’s picture

dpearcefl commented
Status: Active » Closed (won't fix)

Considering the time elapsed between now and the last comment plus the fact that D5 is no longer supported, I am closing this ticket.