| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Hugo <htakada(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: help with utf8 |
| Date: | 2005-12-01 14:18:51 |
| Message-ID: | 438F064B.7000706@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | marcelo Cortez | 2005-12-01 14:46:43 | encoding problem |
| Previous Message | Medora Schauer | 2005-12-01 14:11:36 | fatal error in pg.log |