Re: [ADMIN] Converting from SQL_ASCII to UTF8

2007-11-29 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > I have some UTF-8 data in my databases, and it's causing dump/restore > to fail. Specifically, I'm seeing messages like: > pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence > for encoding "UTF8": 0xe14c65 This is, in fact, not UTF8,

[ADMIN] Converting from SQL_ASCII to UTF8

2007-11-29 Thread Peter Koczan
Hi all, I'd like to move my database encoding from SQL_ASCII to UTF8, mostly because "No encoding conversion will be done when the setting is SQL_ASCII. Thus, this setting is not so much a declaration that a specific encoding is in use, as a declaration of ignorance about the encoding." (from http