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.

Use blob literal instead of hex literal for BLOB in SQLite

true_mogician's profile image true_mogician posted 3 weeks ago in General Permalink

Environment

  • Windows 10
  • HeidiSQL v11.3.0.6295
  • SQLite 3

Description

When using the text editor of HeidiSQL to update or insert a blob, the content will be converted to a hex literal. It works fine if the content is short, but when the blob is large enough, like several MBs, the literal will exceed the limit of hex literal, causing SQL error: hex literal too big.
Using blob literal X'...' instead of hex literal 0x... will solve this problem.

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.