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

Exécution de la commande

file -bi data.sql
text/plain; charset=utf-8

Je vais extraire une petite table ayant un problème...
en mode copy puis insert ....

A+
Pierre

Pierre.

G+ <https://plus.google.com/u/0/107377830070954284209/about>

Le 22 août 2013 09:50, Nabil Servais <nabil(dot)servais(at)gmail(dot)com> a écrit :

> 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>
>>
>>
>