Re: Problem with COPY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brauner Oliveira <brauner(dot)rno(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with COPY
Date: 2013-07-03 13:51:44
Message-ID: 5892.1372859504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Brauner Oliveira <brauner(dot)rno(at)gmail(dot)com> writes:
> ERROR: value too long for type character varying(8)
> SQL state: 22001
> Context: COPY $tablename, line 1, column $colum_name: "69900900"

Is that the first field of the first line?

> The file is well formatted and Encoded in UTF-8:

I'm suspicious that you prepared the file in some text editor that
"helpfully" inserted an invisible BOM (byte order mark) character at the
start of the file. Windows editors in particular seem to think this is
a good idea.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brauner Oliveira 2013-07-03 14:05:04 Re: Problem with COPY
Previous Message Brauner Oliveira 2013-07-03 13:07:33 Problem with COPY