Hello, firstly, I love HeidiSQL. Thanks to everyone who has developed it!
I've just updated to 184.108.40.20668 and the editor now only shows me the first 258 characters of a text field.
I see from the forums that this is a problem that's been an issue for many years, but it's just occurred after upgrading from v11 to v12 today.
What is different to some people is that hovering over the field and saving as BLOB are also truncated.
A workaround is to write and run a SELECT query in the SQL editor, find the row that needs to be edited and then the Heidi editor shows the complete text. It also allows me to update it.
One forum post suggested changing the font in the editor to courier, but this didn't work for me.
My system is Windows 11, heidi reporting envrionment Windows v10.0.
Here is my table structure:
-- Server version: 5.5.58-0+deb7u1 - (Debian) -- Server OS: debian-linux-gnu -- HeidiSQL Version: 220.127.116.1168
-- Dumping structure for table spacenode.app_tests
CREATE TABLE IF NOT EXISTS
test_id int(10) unsigned NOT NULL AUTO_INCREMENT,
pass_message text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
I'm connecting via an SSH Tunnel.