By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,514 Members | 794 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,514 IT Pros & Developers. It's quick & easy.

Character conversion issues while upgrading database

P: n/a
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 <kl*****@svana.org> 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


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/PH5YY5Twig3Ge+YRAlyRAKDH/Qx0DXLjRRIJp9Gb9PKRBDO5PQCg2I26
PSVWsrdShPBoAn3fwwxkjeI=
=6yqs
-----END PGP SIGNATURE-----

Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.