problem on 7.4 with COPY
Toby Doig wrote:
...
>So, what is going wrong? Why can't I import this very simple unicode
file?
>I've searched the archives and google, but to no avail.
>
>
try converting the file to utf-8.
iconv -t utf-8 -f utf-16 < unicode-
Toby Doig wrote:
...
So, what is going wrong? Why can't I import this very simple unicode file?
I've searched the archives and google, but to no avail.
try converting the file to utf-8.
iconv -t utf-8 -f utf-16 < unicode-file.txt > utf-8-file.txt
---(end of broadcast)
When I try to import data from a unicode file into PostgreSQL 7.4 under FreeBSD it
appears to now understand the Unicode file format.
To demonstrate I export a set of Integers into a Unicode file from MSSQL 2000. I samba
the file to a FreeBSD box and try to import from psql with COPY. It fails.
