On 2009-10-30 22:26, Roman Sokolyuk wrote:
Hi,
I installed MonetDB on Vista and am experiencing issues with the COPY utility and uploading text. Text that comes from CVS files and looks plain in Notepad generates errors like this one: *!SQLException:sql:value '505' while parsing '505,787, !SQLException:importTable:failed to import table*
Is it possible I installed Monet without UTF-8 support? How can I check? How can I fix it?
If it looks good in Notepad, perhaps it isn't UTF-8. And even if it is, you may need to tell mclient what encoding you're using. If you're using the MonetDB SQL Client entry in the Start menu, the encoding used is cp437. If that is not the encoding of the data, you will need to specify an encoding manually by running the cmd script from a cmd window. Something like "C:\Program Files\MonetDB\MonetDB5\mclient.bat" -lsql -Eutf-8