On Mon, Sep 15, 2008 at 4:39 PM, Ron Michael Khu <[EMAIL PROTECTED]>wrote:
> There's a postgresql mailing list :D > I already posted also in their mailing list. It's just a matter of who gives the ideal solution first. hehe. :) > pg_dump and most of the console postgresql commands apparently uses > client_encoding. I forgot this fixed but they just set some > environment variables. By the way, ridvan unsa ang database encoding? > UTF-8 pud? or something region-based like EUC_JP shift-JIS?? > Both the target and source DBs are in UTF-8. I checked the sql file generated by pg_dump and it contains some weird characters. Hope ka remember pa sila sa solution para maka inqurie ko. hehe. Ridvan, sa import ni cya nagka problem noh and not sa data dumping, noh? > Yes, ang problem gyud is the generated script upon pg_dump. The contents of the data kay mga text messages man gyud. This is an SMS Ticketing database. So probably kanang mga smiley2x na pa cute or whatsoever european characters ang dahilan. So I really don't know if that's the problem. But I bet there should be some workaround on this. :-) > > > ----- Original Message ---- > From: Ridvan Lakas ng Bayan S. Baluyos <[EMAIL PROTECTED]> > To: Kagay-Anon Linux Users' Group (KLUG) Mailing List < > [email protected]> > Sent: Monday, September 15, 2008 3:55:42 PM > Subject: [klug] [KLUG] invalid byte sequence for encoding problem > > Hi list, > > Any database administrators here or mga PostgreSQL gurus? 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 <secret> 2.6.9-42.0.8.EL #1 Tue Jan 30 12:10:22 EST 2007 > i686 i686 i386 GNU/Linuxclient - 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 <secret> 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". > > > I'll thank you later. > > > Ridvan > > -- > リヅバン バルヨス > [EMAIL PROTECTED] > 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. > > > _________________________________________________ > Kagay-Anon Linux Users' Group (KLUG) Mailing List > [email protected] (http://lists.linux.org.ph/mailman/listinfo/klug) > Searchable Archives: http://archives.free.net.ph > -- リヅバン バルヨス [EMAIL PROTECTED] 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.
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://lists.linux.org.ph/mailman/listinfo/klug) Searchable Archives: http://archives.free.net.ph
