Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Popup editor has truncated string

amonette@billets.ca's profile image amonette@billets.ca posted 2 weeks ago in Feature discussion Permalink

Cells for long strings are truncated and never populated. On hover / column resize complete string is shown. The popup editor is filled with the truncated string.

3 attachment(s):
  • 1
  • 2
  • 3
ansgar's profile image ansgar posted 2 weeks ago Permalink

Yes, this is an issue caused by null characters in the text, e.g. in serialized PHP code.

ansgar's profile image ansgar posted 2 weeks ago Permalink

I just tested an approach where HeidiSQL replaces any #0 character with #32 in results. Displaying such strings would work then. But that would be a silent data manipulation. And PHP would throw an error when trying to unserialize such code:

PHP recoverable error in test.php, line 16: Object of class __PHP_Incomplete_Class could not be converted to string

amonette@billets.ca's profile image amonette@billets.ca posted 2 weeks ago Permalink

I really don't believe manipulating the data is the correct approach. This would make the string seem editable, but would actually corrupt the data. When dealing with more complex serializations etc.. this could make it quite a pain to reverse.

I think making the field un-editable would probably be safer if it cannot support it fully. Right now certain manipulations will save the truncated string etc...

In my use case I was simply trying to copy the field to another row.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.