pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Export from 7.4 and import to 8.0 - unicode errors
2+ messages / 2 participants
[nested] [flat]

* Export from 7.4 and import to 8.0 - unicode errors
@ 2004-10-14 04:28 Scott Chapman <scott_list@mischko.com>
  2004-10-14 06:14 ` Re: Export from 7.4 and import to 8.0 - unicode errors Markus Bertheau <twanger@bluetwanger.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Scott Chapman @ 2004-10-14 04:28 UTC (permalink / raw)
  To: pgsql-admin

I'm getting Unicode errors when I export (with pg_dump) my database from 
version 7.4 and then import it into a new 8.0 database (with psql). 

The situation is that this data has fields with ascii characters in them and 
utf-8 characters also.  Both types of characters are in a given field.  The 
entire dump is NOT utf-8 encoded.

I can't figure out how to get this to be imported into the new database 
without errors unless I turn the entire thing into utf-8 using recode. That 
does not work well because the fields in question have to be utf8_decoded (in 
php) TWICE before they display correctly.

How do I deal with this?  It's got me very puzzled!

Thanks!
Scott



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Export from 7.4 and import to 8.0 - unicode errors
  2004-10-14 04:28 Export from 7.4 and import to 8.0 - unicode errors Scott Chapman <scott_list@mischko.com>
@ 2004-10-14 06:14 ` Markus Bertheau <twanger@bluetwanger.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Markus Bertheau @ 2004-10-14 06:14 UTC (permalink / raw)
  To: Scott Chapman <scott_list@mischko.com>; +Cc: pgsql-admin

В Чтв, 14.10.2004, в 06:28, Scott Chapman пишет:
> I'm getting Unicode errors when I export (with pg_dump) my database from 
> version 7.4 and then import it into a new 8.0 database (with psql). 
> 
> The situation is that this data has fields with ascii characters in them and 
> utf-8 characters also.  Both types of characters are in a given field.  The 
> entire dump is NOT utf-8 encoded.

ASCII is a subset of UTF-8, so every ASCII character is a UTF-8
character, too.

> I can't figure out how to get this to be imported into the new database 
> without errors unless I turn the entire thing into utf-8 using recode. That 
> does not work well because the fields in question have to be utf8_decoded (in 
> php) TWICE before they display correctly.
> 
> How do I deal with this?  It's got me very puzzled!

What encoding is the 7.4 database in? What encoding is the 8.0 database
in? Did you set client_encoding? What's the error message?


-- 
Markus Bertheau <twanger@bluetwanger.de>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-10-14 06:14 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-14 04:28 Export from 7.4 and import to 8.0 - unicode errors Scott Chapman <scott_list@mischko.com>
2004-10-14 06:14 ` Markus Bertheau <twanger@bluetwanger.de>

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