Re: help with utf8 - Mailing list pgsql-general

From Richard Huxton
Subject Re: help with utf8
Date
Msg-id 438F064B.7000706@archonet.com
Whole thread Raw
In response to Re: help with utf8  (Hugo <htakada@gmail.com>)
Responses Re: help with utf8
List pgsql-general
Hugo wrote:
> don't know if this is the best solution but I dropped the database and
> recreated it with SQL_ASCII instead of UTF-8 and everything worked as
> expected

It would SQL_ASCII just accepts whatever it's given.

Hugo - a quick tip for future questions, just post the text of the
message not a picture of it. The picture is much larger than the text
and can't be indexed by Google or the mailing-list archive software.

The error you are getting is "invalid UTF-8 byte sequence". I would
guess it's the point in the data marked by the question-mark: "ALEJO
GARCIA N?367"

1. Are you sure that the byte-sequence you have is UTF-8 (and not UTF-16
or other)?
2. How have you tested this?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: marcelo Cortez
Date:
Subject: encoding problem
Next
From: Tom Lane
Date:
Subject: Re: encoding problem