Re: encoding question - Mailing list pgsql-admin

From Tom Lane
Subject Re: encoding question
Date
Msg-id 9058.1142898110@sss.pgh.pa.us
Whole thread Raw
In response to encoding question  ("Ben K." <bkim@coe.tamu.edu>)
Responses Re: encoding question
List pgsql-admin
"Ben K." <bkim@coe.tamu.edu> 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

pgsql-admin by date:

Previous
From: Ivo Rossacher
Date:
Subject: Re: encoding question
Next
From: John DeSoi
Date:
Subject: Re: Character encoding problems and dump import