International characters in MonetDB

aaaaaa ggggggg veriveri24 at
Mon Jul 15 15:54:31 CEST 2013

Hi Sjoerd,

Thanks for that information! worked like a charm. I just had to convert the ascii file to UTF8 encoding using :
iconv -f iso-8859-1 -t utf-8 Filename.csv > Filename.utf8.csv

Converting all files for bulk reading to utf8 seems to have speeded up the reading process a bit as well!

I have a follow up question :
My original Data is in XML format (I have the XSD file as well). I couldn't find a good/clear example of how to use MonetDB5 to read an XML file into the database, preserving the schema in the XML file.
It would be very helpful if you could give some pointers.

Best Regards

 From: Sjoerd Mullender <sjoerd at>
To: users-list at 
Sent: Monday, July 15, 2013 3:03 PM
Subject: Re: International characters in MonetDB

Hash: SHA1

On 2013-07-15 13:27, aaaaaa ggggggg wrote:
> Hello All,
> I have been trying to do some bulk uploads from CSV files into a
> MonetDB database. All the fields in the database are VARCHAR. The
> text in some of the fields contains international characters such
> as : ü, Ó, é  etc.
> When I execute : copy into database from 'filename.csv' using
> delimiters ',','\n','"' NULL as '';
> I get an error stating that the fields with words containing the 
> international characters could not be imported, and the import
> process stops.
> How can I solve this issue? (I am running Monetdb on windows)

When reading CSV files, MonetDB only accepts files encoding using UTF-8.

> Thanks, SG
> _______________________________________________ users-list mailing
> list users-list at 

- -- 
Sjoerd Mullender
Version: GnuPG v1.4.13 (GNU/Linux)
Comment: Using GnuPG with Thunderbird -

users-list mailing list
users-list at
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the users-list mailing list