in reply to Updating/inserting Binary data using DBIx::Class

One very simple solution might be to declare the columns as VARCHAR FOR BIT DATA. Preliminary tests show that in this case, I can store binary strings without explicitly specifying SQL_BINARY!

Update: After testing for a few weeks, I conclude that this solution works well for me. The only non-trivial part was to convert the VARCHAR datatype of the existing columns to VARCHAR FOR BIT DATA, as this requires dropping and re-creating the corresponding tables (as well as all related objects such as indexes and foreign keys). DB2 control center "db2cc" offers to do all that for you; however, be aware that it sometimes gets stuck in the middle of this conversion process---I highly recommend that you make a backup of your database before attempting the conversion.