Re: From ASCII to UTF-8

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/