Hi, We're upgrading an old 7.0 database to 7.3. The old 7.0 database has some high bit characters which we will assume are Latin9. We're trying to upload into a 7.3 UNICODE database. Normal pg_dump -> psql.
At first we had the problem where it considered every highbit character to be a unicode sequence. So we've added: set client_encoding=latin9; \encoding latin9 which solves most of the problems, however it *still* complains about some unicode sequences, even though we told it there wern't any. Also, it seems to lose track of the columns, as \copy spits out 'missing data for column "foo"'. We tried recode but it similar issues. Any ideas? -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > "All that is needed for the forces of evil to triumph is for enough good > men to do nothing." - Edmond Burke > "The penalty good people pay for not being interested in politics is to be > governed by people worse than themselves." - Plato
pgp00000.pgp
Description: PGP signature
