pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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