"Ben K." <[EMAIL PROTECTED]> writes: > I thought UTF8 was safe if all I have is ascii,
It is, but evidently what you have is not all ASCII. > ERROR: invalid UTF-8 byte sequence detected near byte 0x85 Looks to me like it might have been meant as LATIN1 or one of the other single-byte ASCII-extension encodings. If you think your data should be all ASCII, then you have some data-cleaning to do. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq