Re: Problem with COPY
| От | Brauner Oliveira |
|---|---|
| Тема | Re: Problem with COPY |
| Дата | |
| Msg-id | CADV88-qx6fggR=AKsoQPuaRoxAWpaxG4sx2ooQrpY88JViQ6tg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with COPY (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-novice |
I used Notepad++ and converted the file to UTF-8. But, there's an option to "Convert to UTF-8 without BOM". This time, i used it and worked.
Thank you.
2013/7/3 Tom Lane <tgl@sss.pgh.pa.us>
Brauner Oliveira <brauner.rno@gmail.com> writes:Is that the first field of the first line?
> ERROR: value too long for type character varying(8)
> SQL state: 22001
> Context: COPY $tablename, line 1, column $colum_name: "69900900"I'm suspicious that you prepared the file in some text editor that
> The file is well formatted and Encoded in UTF-8:
"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
В списке pgsql-novice по дате отправления: