Skip site navigation (1) Skip section navigation (2)

Re: Excel a postgre

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Johnny Verdugo <jverdugo(at)gmail(dot)com>
Cc: Jeferson Alvarez <jalvarez(at)renova(dot)com(dot)pe>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Excel a postgre
Date: 2007-12-19 19:26:17
Message-ID: 20071219192617.GM9937@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Johnny Verdugo escribió:

> ERROR: invalid byte sequence for encoding "UTF8": 0xf36e3b47
> Estado SQL:22021
> Sugerencias:This error can also happen if the byte sequence does not match 
> the encoding expected by the server, which is controlled by 
> "client_encoding".
> Contexto:COPY swd_dt_sitios, line 22

Acá el problema seguramente son caracteres no ASCII (acentos, eñes,
etc).  Fíjate lo que hay en la línea 22.  Lo más probable es que, como
dice el HINT, tengas que poner un «SET client_encoding» en alguna parte.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-es-ayuda by date

Next:From: Johnny VerdugoDate: 2007-12-19 19:31:34
Subject: Re: Excel a postgre
Previous:From: Johnny VerdugoDate: 2007-12-19 19:19:49
Subject: Re: Excel a postgre

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group