Devart Forums

Hello,

I have a problem when trying to import data from file coded in cp1250. Normally this code works from command line or MySQL Query Browser, but in dbForge Studio it is not roking with this error: 5 Unknown system variable 'cp1250'

LOAD DATA LOCAL INFILE 'M:\Folder\file.txt' INTO TABLE tablename CHARACTER SET cp1250 FIELDS TERMINATED BY ',' ENCLOSED BY '\' LINES TERMINATED BY '\n';

Am I doing anything wrong?

Hello.

Could you please provide us the steps to reproduce the issue and let us know if you executed a certain part of the query or the whole query.

I want to run just this line and got this message. Nothing more, nothing less. I am using dbForge Studio Express 5.0.54 on Win 7 32 bit (CZE). If you need more information, please, tell me what exactly you need.

Thank you for reporting the issue.

We were able to reproduce it and will fix it in one of the next builds of dbForge Studio for MySQL.

Thank you very much for quick action.

We would like to let you know that the issue was fixed in the new version 5.0.63 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/stu ... nload.html