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