Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
utf8 issue
- From: Tom Hart <tomhart(at)coopfed(dot)org>
- To: Postgres General List <pgsql-general(at)postgresql(dot)org>
- Subject: utf8 issue
- Date: Tue, 26 Feb 2008 14:40:25 -0500
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: 22021Hint: 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 59358Is 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)
- Follow-Ups:
- Re: utf8 issue
- From: Alvaro Herrera
- Re: utf8 issue
- From: Richard Huxton
- Re: utf8 issue
- Prev by Date: Re: how to auto GRANT custom ACL on a new table?
- Next by Date: How to copy tables between databases?
- Previous by thread: Re: [SQL] Deploying PostgreSQL on virtualized hardware
- Next by thread: Re: utf8 issue
- Indexes: