Re: UTF characters compromising data import.

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: UTF characters compromising data import.
Дата
Msg-id ij5j2v$t8v$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на UTF characters compromising data import.  (Gavin Beau Baumanis <beau@palcare.com.au>)
Ответы Re: UTF characters compromising data import.  (Gavin Beau Baumanis <gavinb@thespidernet.com>)
Список pgsql-sql
On 2011-02-08, Gavin Beau Baumanis <beau@palcare.com.au> wrote:

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

if you run it through  
 iconv --from-code=ASCII -to-code=UTF8 -c

it'll strip out all the non-ascii symbols,  without knowing the
encoding it's impossible to assign any useful meaning to them.
This step may render your data useless, it would be much better to
find out what the encoding should be.

perhaps you can figure it out by observation?

-- 
⚂⚃ 100% natural


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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: DELETE FROM takes forever
Следующее
От: Gavin Beau Baumanis
Дата:
Сообщение: Re: UTF characters compromising data import.