utf8 issue
От
Tom Hart
Тема
utf8 issue
Дата
Msg-id
47C46B29.9050507@coopfed.org
Список
Дерево обсуждения
utf8 issue Tom Hart <tomhart@coopfed.org>
Re: utf8 issue Alvaro Herrera <alvherre@commandprompt.com>
Re: utf8 issue Richard Huxton <dev@archonet.com>
Re: utf8 issue Tom Hart <tomhart@coopfed.org>
Re: utf8 issue "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
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)
В списке pgsql-general по дате отправления
