However, now I got an error about the 'ascii' codec being unable to decode
a byte, an ordinal was not in range(128). If I open my data in a text
editor (showing human-legible characters), it says the encoding is Western
(ISO Latin 1). Can I specify this for COPY INTO somehow?
Somewhat worrying, I don't see a relevant option in the documentation:
https://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto
Thanks!
On Wed, May 21, 2014 at 5:28 PM, László Sándor
Perfect, I can verify it works for me as well! http://homepages.cwi.nl/~hannes/importer.py
Thanks a lot,
Laszlo
On Wed, May 21, 2014 at 5:18 PM, Hannes Mühleisen < Hannes.Muehleisen@cwi.nl> wrote:
On 05/21/2014 04:52 PM, László Sándor wrote:
I investigated further, and actually I cannot get any CSV file working with monetDB's COPY INTO on Windows.
Turns out (on Windows), the line terminator has to be specified as \n even if the file uses \r\n.
Best,
Hannes
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list