| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Clodoaldo Pinto" <clodoaldo(dot)pinto(at)gmail(dot)com> |
| Subject: | Re: From ASCII to UTF-8 |
| Date: | 2006-02-26 00:37:50 |
| Message-ID: | 200602260137.51702.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wes | 2006-02-26 00:42:06 | ECPG and COPY and PQputCopyData - don't get errors |
| Previous Message | Clodoaldo Pinto | 2006-02-26 00:33:34 | From ASCII to UTF-8 |