"Jerry Reid" <jereid@hotmail.com> writes:
> This string contains several characters that are outside the normal ASCII
> range. The string could be stored and retrieved using Oracle and MySQL, but
> in Postgres any unusual characters become '?'.
Postgres will happily store anything except a null ('\0') in a text
field. I suspect that either
(a) you have set up the database with some multibyte encoding method
activated, and your funny characters are confusing the multibyte
conversions; or
(b) the mistranslation is happening on the JDBC side.
You might try enabling query logging to see exactly what command is
arriving at the backend when you try to insert this data. That should
determine whether the client or server side is at fault.
regards, tom lane
