| From: | Tom Hart <tomhart(at)coopfed(dot)org> |
|---|---|
| To: | Postgres General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | utf8 issue |
| Date: | 2008-02-26 19:40:25 |
| Message-ID: | 47C46B29.9050507@coopfed.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
SQL state: 22021
Hint: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
Context: COPY transaction_import, line 59358
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?
--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Hart | 2008-02-26 20:19:24 | Re: How to copy tables between databases? |
| Previous Message | Richard Huxton | 2008-02-26 19:19:15 | Re: how to auto GRANT custom ACL on a new table? |