I'd like to export some data to SQL file with TMyDump to be able to import it with TLiteDump later. One of my field is a blob field (with 32 bytes).
Unfortunately neither of two ways with HexBlob true or false does not work. One of then produces a value like: 0x14050944092349222a... which cannot be imported as it appears as too long value. Second one contains inaccessible characters and is exported as NULL value to SQL.
The best would be format x'1405094409.....' which is widely accepted by SQLite. I tried to achieve this format with query as below but I failed.
- this is embraced with apostrophes and internal apostrophes are slashed '\'. Do you have any hint?SELECT CONCAT("x",0x27,HEX(params),0x27)
I d'like to stay with SQL text file to be able to send it through FTP to another PC.