Hi Fabian, The error i get is: !SQLException:sql:value '?»¿1997-01-01 00:00:00' while parsing '?»¿1997-01-01 00:00:00|City Mall|1110|6165|33|8122' from line 0 field 0 not inserted, expecting type date !SQLException:importTable:failed to import table It seems like some chars (?»¿) are added to the first row inserted to the table. The chars do not appear in the csv file (attached). Alfred Fabian Groffen wrote:
Hi Alfred,
On 29-12-2008 00:58:40 -0800, Alfred Nordman wrote:
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.
Do you have any error message? I suspect the DATETIME to be a problem, as your table specifies a DATE, but my knowledge on SQL's date/time/timezone stuff is a bit rusty.
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/Copy-Into-problem-tp21200441p21215000.html Sent from the monetdb-users mailing list archive at Nabble.com.