From: | avalon78 geek <avalon78(dot)gr(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: ERROR: invalid input syntax for integer: SQL state: 22P02 |
Date: | 2012-01-03 12:24:14 |
Message-ID: | CALcq1oOyHaBKojt4W_r9JiYreaUNYsM5SCBVa+dFHuCaxUuA=Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Jan 3, 2012 at 1:30 PM, avalon78 geek <avalon78(dot)gr(at)gmail(dot)com> wrote:
> yes that was i changed editor and worked !
>
>
> On Sun, Jan 1, 2012 at 8:08 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> avalon78 geek <avalon78(dot)gr(at)gmail(dot)com> writes:
>> > i issue the following sql command
>> > COPY cust
>> > FROM 'C:\Program Files\PostgreSQL\9.1\customers.txt'
>> > WITH DELIMITER ';' ;
>>
>> > and i get an error
>> > ERROR: invalid input syntax for integer: "13"
>> > SQL state: 22P02
>>
>> That looks like you have a Unicode BOM marker at the start of the file.
>> There are some (pretty broken IMO) Windows editors that add such behind
>> your back in order to mark a text file as being text ... of course, it's
>> not plain text anymore, and BOM is useless/illegal in UTF-8 anyway, but
>> standards compliance was never Microsoft's strong suit.
>>
>> Save the file with some other editor.
>>
>> regards, tom lane
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | avalon78 geek | 2012-01-03 12:24:44 | Re: ERROR: invalid input syntax for integer: SQL state: 22P02 |
Previous Message | Sergio Sinuco | 2012-01-02 19:13:58 | Re: Lock while delete a table |