taps icon indicating copy to clipboard operation
taps copied to clipboard

Pushing binary/blob data gets currupted

Open jisaacks opened this issue 13 years ago • 2 comments

I pushed some binary data from my local sqlite3 db to a postgres db on heroku.

The data integerity was not maintained.

The data is very long so I wont post it all but here are the first 20 chars before and after:

  • Before: \x89PNG\r\n\x1A\n\x0
  • After: x89504e470d0a1a0a000

jisaacks avatar Aug 11 '12 01:08 jisaacks

Something about it here http://comments.gmane.org/gmane.comp.lang.ruby.sequel/1129

shtirlic avatar Nov 11 '12 21:11 shtirlic

heroku db:push will soon be replaced with pg:push, which won't use taps, so it wouldn't have this problem. It'll have all of its own, new problems! If you want a preview check out https://github.com/heroku/heroku-pg-extras/issues/42

will avatar Sep 03 '13 22:09 will