pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow do I load a 8.0.8 database with unicode encoding into 8.1.4/utf8?
2+ messages / 2 participants
[nested] [flat]
* how do I load a 8.0.8 database with unicode encoding into 8.1.4/utf8?
@ 2006-11-28 11:48 Jessica Richard <rjessil@yahoo.com>
2006-11-28 16:07 ` Re: how do I load a 8.0.8 database with unicode encoding Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jessica Richard @ 2006-11-28 11:48 UTC (permalink / raw)
To: pgsql-admin
got an errro when loading a db from 8.0.8 with unicode to 8.1.4 server with UTF8 server:
ERROR: invalid byte sequence for encoding "UTF8": 0x92
thanks,
Jessica
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how do I load a 8.0.8 database with unicode encoding
2006-11-28 11:48 how do I load a 8.0.8 database with unicode encoding into 8.1.4/utf8? Jessica Richard <rjessil@yahoo.com>
@ 2006-11-28 16:07 ` Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jeff Frost @ 2006-11-28 16:07 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
On Tue, 28 Nov 2006, Jessica Richard wrote:
> got an errro when loading a db from 8.0.8 with unicode to 8.1.4 server with UTF8 server:
> ERROR: invalid byte sequence for encoding "UTF8": 0x92
>
See this info in the HISTORY file:
* Some users are having problems loading UTF-8 data into 8.1.X. This
is because previous versions allowed invalid UTF-8 byte sequences
to be entered into the database, and this release properly accepts
only valid UTF-8 sequences. One way to correct a dumpfile is to run
the command "iconv -c -f UTF-8 -t UTF-8 -o cleanfile.sql
dumpfile.sql". The -c option removes invalid character sequences. A
diff of the two files will show the sequences that are invalid.
"iconv" reads the entire input file into memory so it might be
necessary to use split to break up the dump into multiple smaller
files for processing.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-11-28 16:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-28 11:48 how do I load a 8.0.8 database with unicode encoding into 8.1.4/utf8? Jessica Richard <rjessil@yahoo.com>
2006-11-28 16:07 ` Re: how do I load a 8.0.8 database with unicode encoding Jeff Frost <jeff@frostconsultingllc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox