Skip to content

v3.3.17: Improved multi-lingual support
Compare
Choose a tag to compare
@joyfullservice joyfullservice released this 19 Mar 16:07
v3.3.17
a951098

Summary

Most notable in this release are the removal of the legacy "encryption" feature, the option to select a hashing algorithm, and numerous updates relating to Unicode support.

Special thanks to @hecon5 and @A9G-Data-Droid for some significant contributions to this release!

Enhancements

  • Discard unneeded column metadata when exporting pass-through queries. c098927
  • Remove user information from connection strings when using Trusted_Connection=Yes #181
  • Support other types of path separators besides \. Not technically needed yet, but would be helpful if the add-in is used on another language of Windows, such as Korean. f3a70e1
  • Refactored the Unicode conversion to use the ADODB.Stream conversion rather than API calls. This simplified several complex areas of code and helped with a slight performance increase. We also changed the output to always use the UTF-8 BOM in export files. Thanks, @A9G-Data-Droid for your work on this! #186
  • Referencing the active code page in Windows rather than relying on _autodetect_all for converting VBA code modules. (The autodetect may guess wrong when large numbers of certain extended characters are used in comments.) d84d8b7
  • Added option to select hashing algorithm, now defaulting to SHA256 instead of SHA1. ecbb392
  • Enhanced debugging capability in add-in using a new option to break on errors. 1713533
  • Added option for greater precision in performance logging. Thanks @Tanarri! 1150841

Bug Fixes

  • Fix index date comparison. 284b154
  • Use explicit reference to FileSystemObject. Thanks, @Tanarri! #180, d9f62e3
  • Fixed paging issue in concatenation class. Thanks, @Tanarri! #194
  • Removed (little used) RC4 encryption feature for potential security reasons. Thanks @hecon5! #193

Other Changes

  • PLEASE NOTE: All export files created by the add-in now include a UTF-8 BOM, so you may see a large number of changed files the first time you run an export from the updated add-in.
  • Legacy RC4 Encryption Removed If you were using the Encrypt option with any of your projects, you will want to review #193 and this page for some important changes in this regard.
Assets 3
Loading