Hi! I want to escape binary data correctly either manually or using some pre-defined function that does this for me! I have found on the web: PGconn.escape_bytea but I only get "undefined method". Any ideas, what is the correct way of doing this my self? I'm using Rails (WEBrick) under Windows XP with postgre-pr 0.4.0 I have tried: s_buffer = s_buffer.gsub(/[']/, '\\047') s_buffer = s_buffer.gsub(/[\\]/, '\\134') s_buffer = s_buffer.gsub(/[\0]/, '\\000') /Rick
on 2005-12-21 11:38
on 2005-12-21 17:10
The ActiveRecord does this automatically, as necessary. Or, I've been *very* lucky storing uploaded photos in a BYTEA in PostgreSQL. -- -- Tom M.