12.11$$$3rd party updates:$$$Update plink executables to v0.83. See https://www.chiark.greenend.org.uk/~sgtatham/putty/$$$Update MariaDB Connector/C to v3.4.5. See https://mariadb.com/kb/en/mariadb-connector-c-3-4-5-release-notes/$$$Update SQLite libraries to v3.50.1. See https://www.sqlite.org/$$$Update SQLite multiple cipher libraries to v2.1.3. See https://github.com/utelle/SQLite3MultipleCiphers/releases/$$$$$$New stuff:$$$Issue #604: add context menu item Select top 1000 rows$$$Issue #2175: if asShowRowId option is enabled; show also the index of columns in their header; through the OnAdvancedHeaderDraw/ownerdraw event$$$Issue #2168: select rows from table to export by its primary key columns; so PostgreSQL does not apply a random sorting$$$Issue #2155: paint session background and icon in session drop-down of SQL export dialog$$$Issue #2107: add invert check menu item on table tools tree$$$Issue #2068: support MariaDBs new VECTOR index in table designer; without M and DISTANCE settings yet$$$Issue #2068: support MariaDBs new VECTOR data type in table designer; categorize as binary$$$Issue #2083: add menu item Copy all lines for copying visible and initialized nodes from any VirtualTree instance as CSV data$$$Issue #1975: add keep asking checkbox to reformat dialog$$$Issue #646: forget setting for Favorite objects only on each connection start$$$Issue #2064: support UTF-8 BOM encoding when loading and saving editor files$$$$$$Bugfixes and enhancements:$$$Issue #1253: fix index creation on PostgreSQL tables; use separate CREATE INDEX queries$$$Issue #2187: Fixed EAccessViolation when closing editor while using non-default theme$$$Create helper table with the servers default engine when exporting a view. See https://www.heidisql.com/forum.php?t=44125$$$Issue #2186: fix wrong number of rows shown in grid export dialog when post filter is active$$$Issue #2118: activate legacy-stdio-prompts mode in plink SSH tunnel; to fix non prompted passphrase since plink 0.82$$$Issue #604: sync number of rows to query with the per-page data grid setting$$$Issue #604: support multiple tables and views selected on database tab; in new Select top 1000 rows feature$$$Issue #2172: fix wrong comment$$$Issue #2172: prompt for password again; when connection has timeout or broke$$$Issue #2159: fix memory leak$$$Issue #2159: SQLite: export separated table indexes; and export views and triggers$$$Issue #2168: turn off synchronize_seqscans variable in PostgreSQL mode; to be sure SELECTs show a stable row sorting. See https://www.postgresql.org/docs/8.3/runtime-config-compatible.html#GUC-SYNCHRONIZE-SEQSCANS$$$Issue #1853: try to fix column definition changes on MS SQL wrt collation quoting and default value$$$Issue #2155: high DPI fix for painting icons in SQL export target drop-down$$$Issue #2156: unescape generated column expression when loading from IS.COLUMNS$$$Keep retrieving exact row count on data tab header after activated via context menu; until another table has focus$$$Display number or rows in data tab header for views. See https://www.heidisql.com/forum.php?t=44057$$$Issue #214: when refreshing; ask user if he wants to discard modifications in table/view/routine/... editors$$$Prefer Boolean over Bool type in owned code$$$Issue #2139: fix missing ANDs in REQUIRE clause; and move REQUIRE clause from GRANT to ALTER USER query; as MySQL does not support that in GRANT since v8.x$$$Issue #2133: revert broken characters and encoding of apphelpers unit$$$implementation of Unicode logic for password encryption$$$Issue #2132: fix crash when saving an sql file previously loaded with auto-detected encoding$$$Issue #2123: prevent crash in libpq when disconnecting an already disconnected connection$$$Issue #2128: fix wrong encoding of connection string for PQconnectdb()$$$Issue #2123: fix reconnect mechanism in TPGConnection.Ping()$$$Issue #2119: optimize calculation of status bar panel widths$$$Issue #1986: do not set CLIENT_SSL flag with libmariadb; which seems to ca

3rd party updates:$$$$$$Issue #2076: exchange 32 bit SSL libraries with their 64 bit pendants; fixing SSL connections with libpq and libmariadb

3rd party updates:$$$$$$Issue #1946: update C connector / libmariadb.dll and plugin libraries to latest v3.3.10$$$New stuff:$$$$$$Issue #1284: add support for encrypted SQLite databases; using the C API from utelle/SQLite3MultipleCiphers$$$Issue #1964: support MariaDBs INET4 and INET6 data types$$$Issue #1604: support creating table indexes on SQLite$$$Issue #1604: support adding primary key to new tables; which needs to be done inside the CREATE TABLE code$$$Issue #1605: support dropping table indexes on SQLite$$$Issue #1965: show warnings from custom queries in the bottom log panel; right when they occur; not at the very end of a batch$$$Issue #1428: debug logging of query time and network time after each result-query$$$Issue #1972: Add new security option to verify SSL certificate; in MySQL and MariaDB$$$Get query result tab caption list from -- names: comment; similar to -- name: in a single query$$$Bugfixes and enhancements:$$$$$$Issue #1768 and issue #1426: fix wrong mysql_options() constants for libmysql v8+; to fix SSL connections to servers with OpenSSL 3.x; throwing a SEC_E_ALGORITHM_MISMATCH error. Thanks a lot to Justin Fiedler and Gurianoff for helping out.$$$Issue #1330: Use custom tab width and tabs-to-spaces setting uniquely in all places where we generate code.$$$Issue #1956: Fix retrieval of PG foreign keys on table names which exist in multiple schemata.$$$Support zooming per mouse wheel in the procedure editor and log panel$$$Issue #1951: Add CURRENT_TIMESTAMP function; this time missing in the newer generated functions-mysql8.ini.$$$Issue #1763: fix wrong DPI shown in log panel; and too high donate button after DPI change$$$Issue #1897: Mark grid nodes with vsMultiLine; even if asGridRowLineCount option is set to 1. Fixes endlessly received WM_PAINT messages on results with large lines and tabs in it.$$$Issue #1948: hide menu item for Sequal Suggest dialog.$$$Issue #634: fix HTML in message dialog text containing URLs with trailing double quote$$$Issue #1959: fix shrinking/repositioned edit boxes in options tab of table editor; when opening a second table.$$$Fix and improve exporting in PHP format (@mlocati)$$$Quote restart command in scheduled task item generated by auto-updater$$$Issue #1962: reset width and height of completion proposal when user clicks Reset panel dimensions$$$Issue #1149: reset bottom filter box after switching tables$$$Issue #1952: change log level in TDBQuery.IsEditable from debug to info; when user tries to edit a read-only grid result; so the reason and background is more visible for most users.$$$Issue #1963: fix doubled DPI factor of proposal width and height; due to its own scaling$$$Table editor: disallow editing direction/collation of index node level$$$Issue #1604: fix crash when showing index tab due to uninitialized SubParts and Collations in SQLite and PostgreSQL$$$Silence sporadic crash in TAdoDBConnection.Destroy; found in uploaded crash reports$$$Issue #1967: fix doubled height of donate button with certain fonts; for instance Microsoft YaHei UI$$$Enhance TConnectionParameters.IsMySQL; to turn MySQL or MariaDB 8.0 into MySQL 8.0 in status bar$$$Issue #1971: downsize VARCHAR length to 1 for temporary MySQL tables for views; to work around Row size too large error$$$Issue #1935: indicate unaccepted drop target when dragging folder or session over its current folder

3rd party updates:$$$$$$Issue #1946: update libmariadb.dll and plugin libraries to latest v3.3.8$$$Update regular expression library to v1.181 2023.11.22; supporting \K pattern to set the begin of a reported match.$$$Update InnoSetup compiler to v6.2.2$$$Update VirtualTrees component code to release v8.0.3 (major version update)$$$Issue #1888: Update plink executables to v0.81$$$Update madExcept exception handler to v5.1.4$$$Issue #1905: Update OpenSSL libraries used by libpq-15.dll to v3.1.5$$$Update SQLite libraries to v3.45.3 from 2024-04-15$$$New stuff:$$$$$$Issue #1879: add drop down menu to Apply filter button; with an option to overwrite the current filter based on the different input text$$$Issue #1512: add basic support for indexes with descending column direction$$$Issue #1429: add SQL INSERT IGNORE output format to grid export dialog$$$Issue #178: add database and table filter boxes above tree view on table tools dialog$$$Issue #1917: Support additional UCA collations introduced in MariaDB 10.10.1.$$$Issue #1927: display column comments in completion proposal; give that third column more space to the left and italic style$$$Table editor: when user runs into the cryptic constraint is incorrectly formed message; append a more meaningful line from SHOW ENGINE INNODB STATUS.$$$Support naming result tabs per -- name: xyz comment. See https://www.heidisql.com/forum.php?t=10493$$$Reorder components in grid export dialog; and convert format radio buttons to combobox. Makes the dialog more wide than high; creating space for wider labels and more format options.$$$Issue #1930: Grid export: implement JSON Lines format.$$$Issue #139: Alternating row background colors in table columns list and most other main tabs; if activated by user.$$$Bugfixes and enhancements:$$$$$$Enhance readability of focused text in result grid using dark styles. TreeOptions.PaintOptions.toGhostedIfUnfocused grays out text otherwise.$$$Fix crash in SynCompletionProposalChange; happening when scrolling very fast to the top of the list$$$Fix crash in f_() function with invalid format specifiers from some translation. Happened in Japanese recently.$$$Issue #1870: support VARCHAR columns with a length of 0; in temporary fake tables for exporting views$$$Detect Windows 11 in about dialog; and remove functions only required for the no longer supported Windows Store version$$$Fix activated SSH tunnel for a network type which does not support that; after changing the network type from an explicit SSH-tunnel-type to a TCP/IP version.$$$Search replace: ignore numbers in static row id column$$$Installer: add newly available translations for Hungarian and Bulgarian$$$Add item in Tools main menu for resetting panels to their default dimensions. Useful for quite a few people who move their app window between screens with different resolutions.$$$Static row id: always use the color of the session the result belongs to$$$Performance: call TimerHostUptimeTimer event every 20 seconds only; instead of each second$$$SQL export dialog: cut long file list down to 20 latest items

3rd party updates:$$$$$$Update madExcept exception handler to v5.1.3$$$Upgrading to Delphi compiler version 11.3$$$Update VirtualTrees component code to release v7.6.5a$$$Update vcl-styles-utils from current master branch$$$Update SQLite libraries to v3.44.0$$$Issue #1841: Update OpenSSL libraries used by libpq-15.dll to v3.1.3$$$Update plink executables to v0.79$$$New stuff:$$$$$$Issue #861: New static row id column in all result grids. Uses the session background color; and can be hidden. (see screenshot)$$$Issue #750: SQL formatting now with 2 new online formatters: (see screenshot)$$$https://github.com/doctrine/sql-formatter - hosted on heidisql.com$$$https://sqlformat.org/ - Thanks to Andi Albrecht!$$$Add context menu on data grid header with Query exact row count item; querying SELECT COUNT(*)... on the underlying table$$$Support main tabs in a single line; and support tab-scrolling per mouse wheel$$$Issue #940: Support removing shortcuts per button in preferences. (see screenshot)$$$Issue #1619: Use the same hotkey (Ctrl+S) for saving a table/trigger/... as for saving a query file.$$$Bugfixes and enhancements:$$$$$$Issue #1863: Fixes compatibility to Wine v8.18 again; and probably to more versions$$$Grayscale icons on non-active tabs; for a clearer user interface (see screenshot)$$$Separate double-click and middle-click options for closing tabs (see screenshot)$$$Issue #1795: remove menu items and code for explain analyzer on https://mariadb.org; which is no longer available$$$Issue #1854: fixes incorrect table name used in grid updates when comment with valid query exists$$$Issue #279: Support serial columns in PosgreSQL; which is different from auto_increment on MySQL$$$Issue #872: fix crash when opening a table with columns defined as INVISIBLE; and ensure such columns are selected and visible in the data grid$$$Translation fixes: remove various unused strings; fix some wrong spelled strings; add some missing strings$$$Issue #1850: too short text in popup text editor; when field contains high UTF-8 characters like emojis$$$Add missing PMYSQL_LENGTHS type; and use this for the result of mysql_fetch_lengths(). Fixes an issue broken since 2009 (!)$$$Issue #1640: Fix crash in MouseUp event of query tab close button; by closing/freeing the tab and button through a timer event$$$Issue #752: Fix SQL export on MySQL 8; overwriting view helper tables caused xyz is not view$$$Keyboard shortcuts: allow the user to accept duplicate assignments per ignore button. (see screenshot)$$$Issue #1826: Fix ON UPDATE part of DEFAULT clause with no parentheses on MySQL 8; which are required only for the initial DEFAULT value.$$$Fixes numerous different crashes; found in uploaded crash reports. Thanks to all users reporting these:$$$Fix crash after following a foreign key value$$$Fix sporadic crash Cannot make a visible window modal in search/replace dialog$$$Fix crash in various places where we just try to get the current clipboard text$$$CSV scanner: fix crash when selected filename cannot be opened$$$Fix sporadic crashes in various calls to [TWinControl].SetFocus; with the new class helper .TrySetFocus$$$Fix crash in highlighter customizer; as long as no attribute is selected$$$Silence a popular crash in DBtreeFocusChanged; when trying to detect whether the user clicked into a different session$$$Fix EAccessViolation in TMainForm.DBtreeFocusChanged:124$$$Fix crash when trying to stop current query and the helper connection cannot connect for some reason.$$$Silence sporadic EAccessViolation in DBtreeBeforeCellPaint; when reading DbObj.Connection.Parameters$$$Fix EAccessViolation in TDBObject.GetImageIndex:6$$$Fix EAccessViolation in TMainForm.DBtreeGetText:12$$$Catch different EInOutError exception happening in rare cases of ForceDirectories()$$$Fix EAccessViolation in TMainForm.AnyGridGetText:5$$$Fix crash when user clicks Help button on maintenance dialog; in a non-MySQL session$$$Catch additional EReadError crash in RunQueryFile$$$Fix crash in printer dialog; when printer i

New stuff:$$$$$$Basic implementation of Sequal Suggest as a dialog; under Tools. For generating SQL queries through natural language. See https://sequal.dev/$$$Bugfixes and enhancements:$$$$$$Issue #1800: wrap column default expression in parentheses on MySQL v8.0.13+ when altering a table$$$Issue #1800: attempt to distinguish text values from function expressions in a columns default value; for MySQL 8.0.13+ which seems to allow just all functions as default value.

3rd party updates:$$$$$$Update DDetours sources to latest (2021-01-01)$$$Update vcl-styles-utils sources to latest (2021-01-11)$$$Update gnugettext.pas to rev 148 from http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas$$$PostgreSQL: update OpenSSL libraries to v1.1.1s; taken from http://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries_.28required_for_SSL-enabled_components.29$$$PostgreSQL: Issue #1758: add libpq-15.dll and its 4 dependent files; all signed with my Authenticode certificate (see #1733)$$$madExcept 5.1.2; including a fix for ASLR.$$$New stuff:$$$$$$Issue #921: add SSH tunnel support for SQL Server in TCP/IP mode. SSH tunnel tab is not hidden any longer for unsupported network types; only the checkbox is disabled then.$$$Issue #1721: Let the user disable a sessions SSH tunnel configuration; similar to the SSL checkbox$$$Bugfixes and enhancements:$$$$$$Turn crash into error dialog; on search and replace dialog; when regular expression is invalid$$$Issue #1226: switch back to TSynHotKey again; after using THotKey in shortcut customizer since b4926f3 . Fixes non assignable Enter and Del hotkeys; probably more. This time we dont touch the original TSynHotKey for custom fixes; but through the new TExtSynHotKey.$$$Restore previous scroll position after saving routine; trigger; event or view. See https://www.heidisql.com/forum.php?t=40291$$$Reduce crash probability in TSecureShellCmd.Connect when user disconnects from session before tunnel is reestablished.$$$Strip comments from current query before trying to detect a table alias. Closes #1753$$$Widen import button on very first tab of session manager; so translations fit to it. Closes #1752$$$Find a better alternative to d262a6a : set descending column order on first header click when shift key is pressed . See https://www.heidisql.com/forum.php?t=40243$$$Refactor internal structures for grid/table sorting; prefer TObjectList over Array$$$Issue #1717: block too fast and overlapping calls of refresh action; to reduce crash probability$$$Fix crash due to reset AppSettings.SessionPath through LogSQL()$$$Attempt to fix a crash; happening in some cases when user focuses a tree node in a different connection$$$Disable ASLR and the same flag for 64 bit mode through base configuration.$$$Issue #1568 and issue #1737: exit OnPaintTransient event handler on interlocked calls$$$Hide SSL tab when no session is selected$$$Prefer previously used filename in save-as-snippet dialog. Closes #1747$$$Issue #1730: fix wrong vertical position of linebreaks dropdown$$$Issue #1730: apply font to mother query grid as well; in ApplyFontToGrids$$$Degrade category of mostly log messages from grid editors to debug.$$$Issue #1744: load stored tab file contents always with UTF-8 encoding; to prevent a wrong encoding per auto detection.$$$Issue #1721: fix now wrong tab order with the new SSH tunnel checkbox$$$TConnectionParameters.GetImageIndex: prefer more specific icon for MySQL on RDS sessions$$$Update current year in license file$$$Issue #1730: add preference option for disabling incremental search through typing in grids$$$Include some System.Generics.* units without using projects unit scopes or aliases$$$Issue #1568: fix ineffective temporary disabling of OnChange handler$$$Issue #1568: content in SQL editor is modified in SynMemoQueryKeyPress. Attempt to prevent some endless loop through OnChange event.$$$Remove unit scopes from project settings; prefer fully qualified unit names in uses clauses. Enhance readability and compiler performance.$$$Prefer extracted-comments style over translator-comments; which are not displayed on Transifex for some reason. See https://www.gnu.org/software/gettext/manual/html_node/PO-Files.html#The-Format-of-PO-Files$$$Create project files for Delphi 11.2; with disabled HighEntropyVa setting so the 64bit builds will run without crash.$$$Add comment to joined short+long hint in translation. See 8fc6dba#r93385116$$$Use red background for SQL errors

3rd party updates:$$$$$$Update plink binaries to latest v0.78. Closes #1430$$$New stuff:$$$$$$Make clicks on grid column headers configurable; so the user may disable it; preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026$$$Issue #1705: Add new network type MySQL on RDS; to support its different query for killing a process. New icon provided by @Bens-ct.$$$Bugfixes and enhancements:$$$$$$Issue #1616: force update check to overwrite old HeidiSQL_update in temp directory; once through different file size; and by logic when old one is older than 30 days. Fixes still used old updater with bugs.$$$SQL export: Calculate a reasonable LIMIT clause when Get full table status session setting is disabled; causing AvgRowLen<=0. See https://www.heidisql.com/forum.php?t=40058$$$Fix too narrow column widths restored with high DPI setting; due to Delphis Round() function using the nearest even number. Use the better suited kaufmännisch runden approach.$$$Query helpers tree: sync logic behind Insert at cursor with what doubleclick does. Enables that menu item for table columns; keywords; functions and snippets. See https://www.heidisql.com/forum.php?t=40022$$$Quote BIT values again; in EscapeString version with data type. Closes #1709$$$Use rds_kill_query procedure on RDS to kill a running query. Closes #1705$$$Revert background color of selected text in Material style to its original; again causing unreadable link text on dialogs described in issue #993. Readability of selected text seems more important to me. See https://www.heidisql.com/forum.php?t=40003$$$Include application version and path of selected session in the session managers window caption

$$$Update SQLite libraries to v3.39.4 from 2022-09-29$$$New stuff:$$$$$$Issue #1536: auto-resize height of data grid filter while user types text in it$$$Issue #1691: make timer interval for auto completion proposal configurable; while keeping 500ms as a default value.$$$Allow integers and floats to be entered in hexadecimal format in grids. Basically means theyre not wrapped in quotes now. See https://www.heidisql.com/forum.php?t=39864$$$After restoring query tabs; warn user about tabs which were loading slow$$$Add preference option for adding timestamp to log messages. Helpful for debugging performance issues.$$$Issue #136: use VerySimpleXML v3-beta from https://github.com/Dennis1000/verysimplexml to reformat XML in grid cells. Also; auto-disable slow wordwrap in editor if text is > 1M large$$$Issue #1659: create dialog for customizing highlighter colors and style; for use on grid text editor$$$Highlight occurrences of selected text in grid text editor; same as in query editor$$$Issue #1669: turn customize-highlighter button into dropdown button with additional items Format code once and Always format code. Usable for SQL; JSON and XML.$$$Bugfixes and enhancements:$$$$$$CSV scanner: lowercase name of table and columns; and unify non-word characters to underscore$$$Fix crash when scanning CSV file with more values in data than in header line. Closes #1698$$$Fix trailing linebreak counted to last column name in first CSV line$$$Fix wrong finish message in log result; when doing something different than an export. See https://www.heidisql.com/forum.php?t=39913$$$Issue #1700: exactify positions of line breaks in auto-filter on data grid; to prevent sporadically too long lines$$$Issue #1616; Fix broken updater code and binaries; by fixing wrong parameter definition of WindowProc and wrong type cast in a SendMessage() call$$$Issue #1616: revert previous modifications on updater binaries; which now do nothing and dont trigger the WM_SHOWWINDOW message$$$Issue #1695: attempt to fix a check for a named session before storing the currently used database name$$$Prefer CopyFile + DeleteFile over MoveFile; in a second place; where the old binary is backupd. See issue #1616$$$Add log message after finished export; to make it more noticeable the user has control again. See https://www.heidisql.com/forum.php?t=39913$$$SSH tunnel: process error pipe contents only if std pipe is empty. See https://www.heidisql.com/forum.php?t=39851$$$Allow hex values to have an odd number of digits. See https://www.heidisql.com/forum.php?t=39864$$$Issue #1673; #1351 and #1658: use a general approach in TDBQuery.HasFullData for all server types; where we again use Delphis Length() against a number range of 128..256.$$$Fix text value in popup editor cut to 256 chars; for all modes other than MySQL. Closes #1673$$$Issue #1652: dont add collation clause to a modified or new JSON column$$$Update readme file: add Interbase/Firebird; require Delphi 11.1; code formatting$$$Purge cached columns; indexes etc. and reinitialize table editor; when user presses refresh button. Closes #1628$$$Issue #1669: turn off always-format setting by default$$$Issue #1670: fix text field editing with more than 256 chars on MS SQL$$$Add missing ini entries for CURRENT_TIMESTAMP function. Closes #1666$$$Use empty default host/ip for new SQLite sessions; to avoid running into some out-of-memory issue. Closes #1602$$$Fix previous approach in TDBQuery.HasFullData and StrHasNumChars; which used CharNextW() and stopped at null bytes within binary strings. Again use Length() instead; but let it be longer than GRIDMAXDATA. Closes #1658$$$Issue #1659: remove broken sample text box; activate translation on dialog$$$Issue #1659: fix exception on closing customize dialog; use empty string when converting clNone to and from web color; instead of #ffffff$$$Issue #1656: attempt to give Wine a hint for the right font size; when highlighting selection occurrences$$$Use NULL in new row for column with timestamp expression; to fix

New stuff:$$$$$$Create context menu item Empty recent filters on database and table filter above tree view. See https://www.heidisql.com/forum.php?t=39447$$$Add support for MariaDBs new UUID column type. Closes #1545$$$Add basic support for listing and showing views in SQLite mode. Closes #1196$$$Support mouse wheel zoom in grid text editor$$$Issue #156: menu item follow foreign key in data grid (@dungsaga)$$$Let user set line break style for saved query tab files. Closes #892$$$Issue #892: support custom line break style when saving log panel contents or CREATE code tabs to file; using the existing LineBreakStyle option introduced in 59159c7.$$$Support renaming columns in SQLite; and generate separate ALTER TABLE queries for each change. Closes #1256$$$Support COLLATE clause in SQLite when creating tables$$$Upgrade used compiler to Delphi 11.1$$$Bugfixes and enhancements:$$$$$$Enable 64 bit support for files > 4gb in zipped SQL export$$$Support comments on table indexes via table designer. Closes issue #128$$$Dont add a WHERE -- foo when the filter contains comments only. Closes issue #1537$$$Strip comments from procedure parameters before parsing. Closes issue #1477$$$Restore maximized state of text editor in OnCreate; not OnShow. See https://www.heidisql.com/forum.php?t=39476$$$Dont reset a main controls window procedure if there is no main control. Closes issue #1349$$$SSH tunnel: use the shell executable filename in all dialog captions$$$Issue #287: v5.1 servers report utf8mb4 from mysql_character_set_name; although its latin1. Trust the returned charset only on v5.5+ servers; and reset it on older servers.$$$MoveFile() does not work when target directory is a symlink; so we prefer CopyFile + DeleteFile. Closes issue #1616$$$Auto-fit result columns when compressing export file has finished. Closes issue #1617$$$TSHFileOpStruct.pFrom needs a trailing nul char; see https://stackoverflow.com/a/1594859/4110077 and/or https://docs.microsoft.com/de-de/windows/win32/api/shellapi/ns-shellapi-shfileopstructa?redirectedfrom=MSDN#members$$$When deleting tab backup file; delete it to recycle bin; for cases where the user did that by accident. Same for snippet file and overwritten export/zip file. See https://www.heidisql.com/forum.php?t=39355$$$Set title on completion proposal form; to keep the form resizable with only 1 NbLinesInWindow. See https://www.heidisql.com/forum.php?t=39366$$$Issue #1613: fix missing detection of spatial keys$$$mysql_character_set_name() from libmysql.dll reports utf8* if in fact its a latin* charset. Force utf8* charset in that case. See https://www.heidisql.com/forum.php?t=39278$$$Dont reapply shortcuts to base editor; but to all others. Closes issue #1600$$$Fix crash after copying table to other database; when target database is expanded in DBtree and current session has a background color. Closes issue #1597$$$Optimization: set up a single TSynMemo instance instead of all; e.g. when creating a new query tab$$$Issue #1351: optimize StrHasNumChars$$$Make counting characters in TDBQuery.HasFullData more precise for diacritical characters. Fixes EnsureFullRow not doing its work when a cell contains some emoji. Reported in the forum: https://www.heidisql.com/forum.php?t=39239$$$Leave away delimiter at the end of a query batch; in one-go mode. Closes issue #1583$$$Issue #1577: make apphelpers.SelectNode more intelligent; returning true/false to indicate whether it successful went through OnFocusChanging event$$$Do not auto-close search/replace dialog if no occurrences were found. Closes issue #896$$$Enable cancel edit button after search/replace. Closes issue #1579$$$Issue #1577: break loop in search/replace on grid if advancing focus on next node is not allowed through OnFocusChanging event$$$Convert hardcoded MySQL error codes to named constants; taken from include/mysql/server/mysqld_error.h$$$Refactor: move structures for specific network types out of dbstructures; into their own dbstructures.xxx.pas; and include const.i