[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.
5274
Age (days ago)
5274
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alex Bo.