| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Hart <tomhart(at)coopfed(dot)org> |
| Cc: | Postgres General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: utf8 issue |
| Date: | 2008-02-26 20:42:54 |
| Message-ID: | 47C479CE.5020509@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Hart wrote:
> Hello everybody. I recently converted my db from ASCII encoding to UTF8
> (we have a lot of spanish-speaking members, and need the extra character
> support). Everything was working great, but I noticed this error, while
> trying to COPY one of our tables from a csv.
>
> ERROR: invalid byte sequence for encoding "UTF8": 0xb9
Not converted, I fear.
Why not use latin9 rather than utf8 - that should cover everything and
is probably what it's in anyway.
> Is there anything I can do to look for these sorts of errors and fix
> them? I'm really not great with character encodings and I'm not sure
> where to go on this. Any help?
Google a bit for iconv (and postgresql) to get your characters valid.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-02-26 20:43:54 | Re: How to copy tables between databases? |
| Previous Message | Uwe C. Schroeder | 2008-02-26 20:41:05 | Re: How to copy tables between databases? |