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@archonet.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
