Error when loading data from cp1250 file

Jumboun · Post by **Jumboun** » Thu 01 Dec 2011 11:46

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?

alexa · Post by **alexa** » Thu 01 Dec 2011 14:18

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.

Jumboun · Post by **Jumboun** » Thu 01 Dec 2011 14:44

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.

alexa · Post by **alexa** » Thu 01 Dec 2011 15:54

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.

Jumboun · Post by **Jumboun** » Thu 01 Dec 2011 16:11

Thank you very much for quick action.

alexa · Post by **alexa** » Mon 16 Jan 2012 07:26

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