| From: | "Juan Carlos Azogue" <azoguej(at)tigo(dot)net(dot)bo> |
|---|---|
| To: | <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Error cargando datos CSV : invalid byte sequence for encoding "UTF8": 0xd12c |
| Date: | 2006-12-05 00:40:37 |
| Message-ID: | 6E7FAB383CEB584F9DDB18269CBD284001C8785C@SCZTIGO.tigo.net.bo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Estoy queriendo cargar datos de un archivo de texto y me sale este error
CALL=# COPY consultas.cet_llamada_200610 from '/u01/cet_llamada_20061002.txt' WITH CSV ;
ERROR: invalid byte sequence for encoding "UTF8": 0xd12c
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY cet_llamada_200610, line 38614
La linea que me da error es esta:
850635,04/10/2006 00:00:00,20787,CET,77690872,02/10/2006 00:00:00,02/10/2006 07:22:05,S,L_NUE,HW,01,N,70095210Ã,,,,505,54,0066BDFA54,1,39,0,0,0,02/10/2006
Alguien sabe cual el motivo del mismo.
Juan Carlos Azogue Claure
Administrador de Bases de Datos
TELECEL SA
Santa Cruz de la Sierra, Bolivia
Cel: (591) 773-33006 / (591) 773-90688
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan Carlos Azogue | 2006-12-05 01:03:22 | RE: Error cargando datos CSV : invalid byte sequence for encoding "UTF8": 0xd12c |
| Previous Message | Juan Carlos Alemán Cuadros | 2006-12-04 21:17:12 | RE: [pgsql-es-ayuda] Por donde deberí |