Remember last character set used in "Load SQL File"

phinor's profile image phinor posted 8 years ago in Feature discussion Permalink

I very often need to restore sql dumps using the "Load SQL File" feature. In each case, the files are UTF8 encoded, but they always fail the Automatic detection (the first tables are largely numeric data) and the multibyte UTF characters are then imported as combinations of extended ASCII characters.

I would like to suggest that the "Load SQL File" dialog have the "encoding" option default to the last used option.

Thanks!

ansgar's profile image ansgar posted 8 years ago Permalink

Sounds good!

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5056
Remember selected encoding in several file-open-dialogs. See http://www.heidisql.com/forum.php?t=20868
ansgar's profile image ansgar posted 8 years ago Permalink

r5056 now remembers the previously selected encoding in the following file-open-dialogs:

  • loading an .sql file into a query tab
  • loading a .csv file into the text-import dialog
  • loading a textfile into the popup text editor in a grid text cell

I gave these three dialogs separate settings, as I think the purpose in these 3 situations are also different. That means, if you selected utf8 when loading an .sql file, the textfile import still has auto-detect preselected.

phinor's profile image phinor posted 8 years ago Permalink

Thank you! I have downloaded the 5056 release and can confirm that the Load SQL dialog is remembering the setting!

Please login to leave a reply, or register at first.