Monday, September 15, 2008

[NOVICE] Invalid Byte Sequence for Encoding Error

Hi list,

I'm trying to migrate a database to another server. However, the source is 32-bit while the server that I'm going to have it transferred is 64-bit. Is there any workaround on this? I'm just using a simple `pg_dump` to migrate the database.

ENVIRONMENT:
Source DB: Linux <censored> 2.6.9-42.0.8.EL #1 Tue Jan 30 12:10:22 EST 2007 i686 i686 i386 GNU/Linux
client - psql (PostgreSQL) 8.1.4
server - PostgreSQL 8.1.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
Target DB: Linux <censored> 2.6.15-28-amd64-generic #1 SMP PREEMPT Wed Jul 18 22:51:22 UTC 2007 x86_64 GNU/Linux
client - psql (PostgreSQL) 8.2.7
server - PostgreSQL 8.2.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)

And here's the error when dumping the data to the target DB:
ERROR: invalid byte sequence for encoding "UTF8": 0x80
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".


Thanks in advance for your help.


Ridvan

--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.

No comments: