[MonetDB-users] Inserting '\' into varchar(1)
4 Jan
2010
4 Jan
'10
9:15 a.m.
Hi, I think I found a bug: I can't seem to insert the character '\' into Monet with COPY INTO when I use a single character column: 1. I have a text file that only contains this: '1,"\\"' 2. create table test1 (f1 int, f2 varchar(1)) 3. copy into test1 from 'C:\test1.txt' using delimiters ',','\r\n','"' null as ''; I get: SQLException:sql:value '\\' from line 1 field 2 not inserted, expecting type str If I change the field size from varchar(1) to varchar(2) it works. (Aug09 & Nov09 on Windows) Is this a bug? Thanks & happy new year. -- View this message in context: http://old.nabble.com/Inserting-%27%5C%27-into-varchar%281%29-tp27010393p270... Sent from the monetdb-users mailing list archive at Nabble.com.
5472
Age (days ago)
5472
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alex Bo.