UTF characters compromising data import.

Поиск
Список
Период
Сортировка
От Gavin Beau Baumanis
Тема UTF characters compromising data import.
Дата
Msg-id DB66CD37-D380-4C8A-8239-E90B5BD95073@palcare.com.au
обсуждение исходный текст
Ответы Re: UTF characters compromising data import.  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-sql
Hi Everyone,

I am trying to import some data (provided to us from an external source) from a CSV file using "\copy ...."

But I get the following error message;
invalid byte sequence for encoding "UTF8": 0xfd
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is
controlledby "client_encoding". 

I understand the error message - but what I don't know is what I need to set the encoding to - in order to import  /
usethe data. 

As always - thanks in advance for any help you might be able to provide.


Gavin "Beau" Baumanis


В списке pgsql-sql по дате отправления:

Предыдущее
От: Samuel Gendler
Дата:
Сообщение: Re: why SELECT query needs relationname (schemaName.tableName)
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: UTF characters compromising data import.