Re: UTF characters compromising data import.

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: UTF characters compromising data import.
Date: 2011-02-12 09:15:11
Message-ID: ij5j2v$t8v$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2011-02-08, Gavin Beau Baumanis <beau(at)palcare(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gavin Beau Baumanis 2011-02-13 11:08:41 Re: UTF characters compromising data import.
Previous Message Jasen Betts 2011-02-12 08:09:21 Re: DELETE FROM takes forever