Re: encoding question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: encoding question
Date: 2006-03-20 23:41:50
Message-ID: 9058.1142898110@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Ben K." <bkim(at)coe(dot)tamu(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vlad 2006-03-21 05:27:28 question about "libpq.lib"
Previous Message Ivo Rossacher 2006-03-20 23:21:42 Re: encoding question