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.

Insert files into TXT/BLOB

azielnik's profile image azielnik posted 2 months ago in General Permalink

So far it worked fine. After 2 updates there's warning HEX LITERAL TOO BIG.

It's strange, as I loaded in this way the content of text files, so many files. Now I had html files, so I change the extention to txt and tried to insert. No way HEX LITERAL TOO BIG.

So I decided to check it with my previouse successful files, and the same warning.

I think the updates made bad changes. This command doesn't want to recognise txt file and treat the file as hex signs. Can it be recover?

azielnik's profile image azielnik posted 2 months ago Permalink

Hi Friends

This was my false alarm.

In Insert files into TXT/BLOB, when I had already selected files there was checked BINARY check, hence the problem. The dialog box was too small and intentionally I thought this is the file selector. My stupid mistake.

Anyway, someone could me explain why there was the problem with binary insert while files was very small 20K?

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.