Default encoding for externally loaded dumps

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
brezanac
Posts: 33
Joined: Thu 09 Jan 2014 14:52

Default encoding for externally loaded dumps

Post by brezanac » Mon 24 Apr 2017 14:12

Any chance you might reconsider your decision on this?

It's been requested countless times on these forums during the last 5+ years and it keeps being declined on an assumption that the File -> Open option is the only way to load an external SQL file into dbForge.

The issue happens if the SQL file is opened by double clicking on it which results in automatically invoking the default operating system encoding (like Windows1252) without even the option to choose the encoding like in the File-> Open dialog. I don't have to explain how many problems this can cause, from invalid schemas, to corrupt data, unnecessary data synchronizations etc.

The solution should be very simple: add a default encoding setting in the options which will be always used during external SQL file loading unless it's overridden in the File->Open dialog.

P.S. Relying on BOM character to identify encoding for UTF8 dumps is completely wrong since MySQL doesn't support that kind of behavior.

alexa

Re: Default encoding for externally loaded dumps

Post by alexa » Wed 26 Apr 2017 07:15

We will investigate this issue and will answer you as soon as possible.

alexa

Re: Default encoding for externally loaded dumps

Post by alexa » Thu 22 Jun 2017 11:04

We do apologize for the delay on this.

Could you please send us the file you are experiencing the issue with for investigation?

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom.

Post Reply