[MonetDB-users] Copy Into problem

Hi there,

I'm trying to use the copy into with csv file (utf-8 encoded) and I encounter some problem. The create statement is:

CREATE TABLE "sa3e7e9f4d666429ea2c5bb61a532f5b9" ("A" DATE ,"B" VARCHAR (22) ,"C" DECIMAL (12, 5) ,"D" DECIMAL (12, 5) ,"E" DECIMAL (12, 5) ,"F" DECIMAL (12, 5) )

The copy into statement is:

COPY INTO "sa3e7e9f4d666429ea2c5bb61a532f5b9" FROM 'T:\Prism\Applications\Desktop\PrismDesktop\bin\Debug\LocalRepository\ImportedCSV\ImportedCSV0.csv' USING DELIMITERS '|' NULL AS 'A56A9FC261A143a48F6019F602ABF409';

And csv is attached.

Any advice?!?!?!

tnx,

Alfred. http://www.nabble.com/file/p21200441/ImportedCSV0.csv ImportedCSV0.csv