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 <sandorl@gmail.com> wrote:

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