- Windows 10
- HeidiSQL v184.108.40.20695
- SQLite 3
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.