Re: Copying into Unicode - Correcting Errors

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Hunter Hillegas <lists(at)lastonepicked(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Copying into Unicode - Correcting Errors
Date: 2004-11-24 10:19:44
Message-ID: 200411241119.44894.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hunter Hillegas wrote:
> I need to import a file into a Unicode database.
>
> I am getting an error:
>
> ERROR: Unicode characters greater than or equal to 0x10000 are not
> supported
> CONTEXT: COPY mailing_list_entry, line 30928, column
> first_last_name: "Ver?nica"

If your file really does have Unicode characters greater than or equal
to 0x10000, then I don't have a good answer.

But more often, this error means that your file is not in Unicode in the
first place. If so, set the client encoding to the real encoding of
your file, e.g.

export PGCLIENTENCODING=LATIN1

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Fiche 2004-11-24 10:34:41 Re: Creating index on a view?
Previous Message Peter Eisentraut 2004-11-24 10:14:37 Re: Creating index on a view?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-11-24 10:57:44 Re: Patch for jdbc escaped functions
Previous Message Oliver Jowett 2004-11-24 09:37:35 Re: [JDBC] Strange server error with current 8.0beta driver