Postgres: trying to fix some unicode encoding issues
If what you see is donÃ¢\u0080\u0099t then those are literal backslashes in your table, not escape sequences.

Try to double the backslashes to get literal ones:

select col from tab where col ~~ E'%\\u0080%';


And use the proper E'' syntax for PostgreSQL 8.4 with that.