29 Dec
2008
29 Dec
'08
8:58 a.m.
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
--
View this message in context: http://www.nabble.com/Copy-Into-problem-tp21200441p21200441.html
Sent from the monetdb-users mailing list archive at Nabble.com.