On Sun, Dec 28, 2008 at 07:51:28AM -0800, Alfred Nordman wrote:
Hi there,
I'm trying to use the copy into with csv file (utf-8 encoded) and I encounter some problem.
Hi Alfred,
Which version of MonetDB/SQL are you using?
Which kind of problem(s) do you encounter?
Stefan
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/p21193416/ImportedCSV0.csv ImportedCSV0.csv
View this message in context: http://www.nabble.com/COPY-INTO-problem-tp21193416p21193416.html Sent from the monetdb-users mailing list archive at Nabble.com.
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users