Clodoaldo Pinto wrote:
> As part of a migration from 8.0 to 8.1 i want to convert the data
> from ASCII to UTF-8.
ASCII is a subset of UTF-8, so if you really wanted to do that you
wouldn't need to do anything.
> I dumped the database with pg_dump (8.0) and tried to convert it with
> iconv, but it shows an error:
>
> $ iconv -t ASCII -t UTF-8 fahstats_data.dump -o
^^ ^^
Mistake?
> fahstats_data_utf-8.dump iconv: illegal input sequence at position
> 71407864
>
> That position contains the decimal value 233:
Well, that is not an ASCII character, so you need to use a different
source encoding for iconv.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
