| From: | "Clodoaldo Pinto" <clodoaldo(dot)pinto(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | From ASCII to UTF-8 |
| Date: | 2006-02-26 00:33:34 |
| Message-ID: | a595de7a0602251633i4f2c9e5y@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
As part of a migration from 8.0 to 8.1 i want to convert the data from
ASCII to UTF-8.
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 fahstats_data_utf-8.dump
iconv: illegal input sequence at position 71407864
That position contains the decimal value 233:
$ od -A d -j 71407864 -N 1 -t u1 fahstats_data.dump
71407864 233
71407865
I could use pg_dump -E in 8.1 but it is in another machine with ADSL
connection and the dump size is 1.8GB. It would take more than 12
hours.
How to install pg_dump 8.1 only? I tried to copy the executable and
the libs but it did not work.
Regards, Clodoaldo Pinto
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-02-26 00:37:50 | Re: From ASCII to UTF-8 |
| Previous Message | chris smith | 2006-02-26 00:16:59 | Re: createuser permssion for group |