Martijn van Oosterhout wrote: > This may be the only solution. Converting everything to UTF-8 has > issues because some encodings are not roundtrip-safe (Enc -> UTF8 -> Enc > gives you a different string than you started with). There's probably > no encoding round-trip safe with every other encoding.
Is this still true? If I remember clearly, Tatsuo-san had asserted that this was the case, but later he said there was some bug in our conversion routines or the conversion tables. So maybe now that those things are fixed (they are, aren't they?) there _is_ a safe roundtrip from anything to UTF8 and back. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster