Re: Updating/inserting Binary data using DBIx::Class

Hi hrr

* what version of DB2 you are using ?

Note: Binary Data type will be supported from DB2 version 9.

however, this did not work...
are you getting any error message ?

__PACKAGE__->add_columns(col_name => {data_type => DBI::SQL_BINARY});
[download]

Tell something about the above statement's result ? In what OS you are running the above program ?

"Keep pouring your ideas"

Comment on Re: Updating/inserting Binary data using DBIx::Class Download Code

Replies are listed 'Best First'.
Re^2: Updating/inserting Binary data using DBIx::Class by hrr (Monk) on Aug 21, 2006 at 13:06 UTC
Hi jesuashok: Thank you for thinking about my problem! More details are as follows. DB2 Version 8.1.2. (It seems that I can insert binary strings using this DB2 version, since `bind_param(... {TYPE => DBI::SQL_BINARY})` works well.) OS: Linux, openSUSE 10.1. There is no error message. However, character codes larger thatn 127 are reduced to a smaller value. For example, `chr(0xe3)` is changed to `chr(0x1a)`. I find out the latter code by using a `SELECT ASCII(col_name) FROM ...` query.	[reply] [d/l] [select]
A reply falls below the community's threshold of quality. You may see it by logging in.