Date: 2015-11-17 10:03:28 +0100
From: MRA <>
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)

Last updated: 2016-01-15 11:37:59 +0100

Comment 21531

Date: 2015-11-17 10:03:28 +0100
From: MRA <>

User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36
Build Identifier:

We have in our database a field defined with VARCHAR(5) and a chinese string "不要让早把" to be inserted.

If we insert the string with SQL insert everything works find, but if we try to insert via BULK monet throw an error.
I made several test and i need to extend the varchar from 5 to 10 to get the bulk insert working.

Reproducible: Always

Steps to Reproduce:

create table test.varcharsize5
(
id int,
varchar106 varchar(5),
primary key (id)
);

insert into test.varcharsize5 values (1,'不要让早把');

BULK Line to insert in a file:
"1","不要让早把"

COPY 10 RECORDS INTO test.varcharsize5 FROM '/root/test_varchar_chinois'
USING DELIMITERS ',','\n','"' NULL AS '\N' ;

Actual Results:

Failed to import table line 1 field 2 'varchar(5)' expected in '不要让早把'

Expected Results:

Should be insterted

Comment 21532

Date: 2015-11-17 10:47:02 +0100
From: MonetDB Mercurial Repository <>

Changeset d35f9308f670 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=d35f9308f670

Changeset description:

Added test for bug #3864.

Comment 21533

Date: 2015-11-17 10:47:42 +0100
From: @sjoerdmullender

Fixed with changeset 535bb896b400