Re: [pgsql-fr-generale] Error chargement de données.

Bonjour,

Que donne le résultat de la commande file -bi data.sql ?

Si ça retourne autre chose que "text/plain; charset=utf-8", il faut
reconvertir le fichier avec iconv.

On Thu, Aug 22, 2013 at 9:42 AM, Pierre BOIZOT <pierre(dot)boizot(at)gmail(dot)com>wrote:

> Bonjour,
>
> je rencontre une erreur que je ne comprends pas
>
> Log chargement de data
>
> psql.bin:../data/data.sql:4441: ERROR: invalid byte sequence for encoding
> "UTF8": 0xe9 0x6d 0x65
> CONTEXT: COPY aide, line 2
> ROLLBACK
> BEGIN
> psql.bin:../data/data.sql:4448: ERROR: invalid byte sequence for encoding
> "UTF8": 0xe9 0x66 0x69
> CONTEXT: COPY aire, line 1
> ROLLBACK
> BEGIN
> psql.bin:../data/data.sql:4462: ERROR: invalid byte sequence for encoding
> "UTF8": 0xe9 0x72 0x69
> CONTEXT: COPY algue, line 4
> ROLLBACK
>
> Environnement du Shell.
> [migora] locale
> LANG=en_US.utf-8
> LC_CTYPE="en_US.utf-8"
> LC_NUMERIC="en_US.utf-8"
> LC_TIME="en_US.utf-8"
> LC_COLLATE="en_US.utf-8"
> LC_MONETARY="en_US.utf-8"
> LC_MESSAGES="en_US.utf-8"
> LC_PAPER="en_US.utf-8"
> LC_NAME="en_US.utf-8"
> LC_ADDRESS="en_US.utf-8"
> LC_TELEPHONE="en_US.utf-8"
> LC_MEASUREMENT="en_US.utf-8"
> LC_IDENTIFICATION="en_US.utf-8"
> LC_ALL=
> ​
>
> encoding ​Database
> postgres=# \l
> List of databases
> Name | Owner | Encoding | Collate | Ctype | Access
> privileges
>
> -----------+----------+----------+------------+------------+-----------------------
> hr | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
> postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
> sib | sibadmin | UTF8 | en_US.utf8 | en_US.utf8 |
> template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres
> +
> | | | | |
> postgres=CTc/postgres
> template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres
> +
> | | | | |
> postgres=CTc/postgres
> ​
> info sur le fichier.
> data.sql: utf-8 Unicode English text, with very long lines
>
> Je cherche ce qui est faux dans ma configuration.
>
> Par ailleurs lors de l'export des data j'ai plusieurs erreurs
> Wide character in print at /usr/lib64/perl5/IO/Handle.pm line 406.RNAL
> (9340.1 recs/sec)
> Wide character in print at /usr/lib64/perl5/IO/Handle.pm line 406.RNAL
> (9346.7 recs/sec)
> Wide character in print at /usr/lib64/perl5/IO/Handle.pm line 406.RNAL
> (9306.9 recs/sec)
> Wide character in print at /usr/lib64/perl5/IO/Handle.pm line 406.RNAL
> (9326.9 recs/sec)
>
> Pierre.
>
> G+ <https://plus.google.com/u/0/107377830070954284209/about>
>
>