Re: [MonetDB-users] Copy Into problem

On Tue, Dec 30, 2008 at 12:38:54PM +0100, Wouter Alink wrote:

I haven't looked at your document, but it is probably the byte-order mark...

See section: 3.2 Byte order mark (BOM) http://www.ietf.org/rfc/rfc2781.txt

Normal editors/viewers hide it, as it isn't a visible character. I think MonetDB should have stripped it before showing you the error message.

If "magic numbers" and/or "byte order marks" are indeed to be expected in *plain* text (csv) files, then yes, ortherwise, it could only mention that the file does not comply to the expected *plain* text format. Stefan's €0.02 ;-)

My2cts, Wouter

2008/12/30 Niels Nes :

...

On Tue, Dec 30, 2008 at 01:50:32AM -0800, Alfred Nordman wrote:

...

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).

With less you can see the following first chars .

Niels

...

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.

------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

--

Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |