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