HeidiSQL 12.12.0.7122

What's new in this version:

- The v12.12 release now abandons the 32 bit portable releases and nightly builds. Only 64 bit releases from now on.
- Back in Jan 2019, for v10.0, I created the first 64 bit release with the support of the Delphi 10.3 at that time. Since that release I provided both 32 and 64 bit releases for more than 6 years now. Due to the decreasing availability of 32 bit drivers and libraries, and with a user base of ~0.5% it makes sense to safe the effort for these. Note the previous releases with 32 bit variants are still available on the download page.
- Also notable: heidisql.com has been moved to Manitu, an excellent hosting provider in Germany. Update checks, SQL formatting and statistic calls should benefit from the enhanced speed.

New stuff:
- Support for trigger editing on SQLite

3rd party updates:
- Upgrade compiler to Delphi 12.3.
- Update MariaDB Connector/C to v3.4.7
- Add MySQL Connector libmysql v9.0.4
- Update SQLite libraries to v3.50.4
- Update SQLite multiple cipher libraries to v2.2.4
- Update PostgreSQL libpq/17 to v17.0.6
- Update PostgreSQL libpq/15 to v15.0.14
- Remove PostgreSQL libpq/10 and 12, depending on the outdated and insecure libssl v1.1.1w
- Update Virtual-TreeView component to v8.2 from Sep 5 2025

Fixes and enhancements:
- fix reading and writing user limitations in newer MySQL versions
- rephrase SQL query for retrieving the oid of citext data type, to prevent errors in the server logs
- fix height of grid column header
- support table comment syntax when creating new PostgreSQL tables
- se N(ational) prefix on MS SQL strings on all quoted strings, regardless of their exact data type, to support Unicode in meta queries as well
- remove fallback to insecure http calls when https failed
- use N(ational) prefix in MS SQL for any text value going through the second version of EscapeString(), supporting Unicode now when importing a file into a table.
- Fix unsaved highlighter selection of default "General"
- Fix memory leak
- call FixVT() in FormCreate consequently, so the trees do not change their row height after the second use. Also increase TextMargin and reduce Margin.
- keep UserKnownHostsFile enabled in ssh.exe mode, so the message saying "permanently added xyz to the list of known hosts" is telling the truth now
- Do not require a "Content-Length" response header in THttpDownload. Responses mostly come compressed with "Transfer-Encoding: chunked" and then need hacks to get a Content-Length header
- support MariaDB's COMPRESSED attribute for columns in table editor
- suppress prompt to save a yet unknown host key in ssh.exe mode, by disabling StrictHostKeyChecking and UserKnownHostsFile . I have no clue to where ssh.exe sends that message, it's neither in stdOut nor in stdErr.
- fix input being ignored by plink by adding a linefeed after y/n
- add -legacy-stdio-prompts argument only to plink v0.82 or newer, not on older versions
- fix detection of column length in SQLite, when the column type contains a space before parenthesis
- add type prefix to export file name, when exporting one file per object, to fix overwriting same filename for different object types
- don't disable completion proposal when cursor is right besides a string or comment
- Remove subpart from column indexes when user changed its data type to non-text
- expect some more characters to indicate a boundary for an identifier: ! < >
- Table data generator: use only space, new line and letters in text columns, and limit to 1024 characters
- move foreign key column value behind the text value, in the grid foreign key drop-down, so a user may select an item by typing letters
- Leave space for column id in grid column headers
- Invisible virtual column syntax is generated wrong