Use blob literal instead of hex literal for BLOB in SQLite

true_mogician's profile image true_mogician posted 2 years 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.

true_mogician's profile image true_mogician posted 2 years ago Permalink

Nobody's here? I'm still looking forward to a fix on this bug, which doesn't seem hard.

fihovi's profile image fihovi posted 2 years ago Permalink

The best way would be to create issue on GitHub, I think.

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