Error chargement de données.

From: Pierre BOIZOT <pierre(dot)boizot(at)gmail(dot)com>
To: PG-Mail-liste <pgsql-fr-generale(at)postgresql(dot)org>
Subject: Error chargement de données.
Date: 2013-08-22 07:42:21
Message-ID: CANxSh5yPpxGSyarbCGZ9dhCiXGz8Z4DpF+g=N_oubqVJfFtLpg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

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>

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Nabil Servais 2013-08-22 07:50:34 Re: [pgsql-fr-generale] Error chargement de données.
Previous Message Guillaume Lelarge 2013-08-13 12:21:27 Re: Oracle 2 pg