| 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/
| 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? |
| 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 |