Re: help with utf8

Richard,

I have to import data from a CSV file with the pgsql COPY command, I just
know that this file comes from an old program written in Clipper (or
something like under linux) , my database was created with UTF8, I cant
find how to create it with UTF-16 on windows, what is the recomended
encoding for Postgres on windows spanish version.

Yes, the problem is in that point , it shoud read "ALEJO GARCIA Nº 367".

thanks for you help

Hugo

On 01/12/05, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> 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
>