"philip" <philipguo(at)yahoo(dot)com> writes:
> I installed PostgreSQL 8.0.3 database system on both platforms MS Windows XP
> (sp1) and Linux Fedora 3, and both databse settings are exactly the same
> with the encoding set to 'UNICODE'.
Windows' support for UNICODE is kind of broken I'm afraid :-(. You
should use a different encoding on that platform, at least until we
figure out an end-run around the OS' limitations.
regards, tom lane