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 SG ________________________________ From: Sjoerd Mullender <sjoerd@acm.org> To: users-list@monetdb.org Sent: Monday, July 15, 2013 3:03 PM Subject: Re: International characters in MonetDB -----BEGIN PGP SIGNED MESSAGE----- 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@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQCVAwUBUePzFz7g04AjvIQpAQKH1QP/aqd2qIi24Ay/7aSoHrvGoFoFiyRJXglT 6nHJUx/iiBtY/shFXDzkpdcxkYVO8YmJgVKSjDic19xFho+n/FFftYmaD24xFMDX ucTt1T3pDx768s1ou05sw5w2aXNvU2Fbh52+N1jBYo/H5Z8LdnHvH1juQQ/+12IR y006Fpjt5pU= =mJDq -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list