International characters in MonetDB
veriveri24 at yahoo.com
Mon Jul 15 15:54:31 CEST 2013
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.
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-----
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.13 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
-----END PGP SIGNATURE-----
users-list mailing list
users-list at monetdb.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the users-list