International characters in MonetDB

aaaaaa ggggggg veriveri24 at yahoo.com
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
SG

________________________________
 From: Sjoerd Mullender <sjoerd at acm.org>
To: users-list at 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 at 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 at monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20130715/e1350491/attachment.html>


More information about the users-list mailing list