International characters in MonetDB

Sjoerd Mullender sjoerd at acm.org
Mon Jul 15 15:03:26 CEST 2013


-----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-----



More information about the users-list mailing list