It should be no problem at all. Is your db unicode encoded like this:

tils@goem:~$ psql -l
        List of databases
  Name    |  Owner  | Encoding
-----------+----------+----------
head      | tils    | UNICODE
...

?