[Dbix-class] Pg bytea does not work

Rolf Schaufelberger rs at plusw.de
Sun Oct 14 19:15:01 GMT 2007


Hi, 

I have a table like this:
 id              | integer                  | not null default 
nextval('orders.logos_id_seq'::regclass)
 name            | character varying(100)   |
 image           | bytea                    |
...

and in my class I have 
...
__PACKAGE__->add_columns ( image => { data_type => 'bytea' });
...

Now when I try to insert something in image I get an error 

DBIx::Class::ResultSet::create(): DBI Exception: DBD::Pg::st execute failed: 
ERROR:  invalid byte sequence for encoding "UTF8":

Debuggung showed me, that 

bind_attribute_by_data_type   is  called in 
D:C:Storage:DBI and not in D:C:Storage:DBI::Pg

All my classes inherit from a base class which does 

__PACKAGE__->load_components(qw/Core PK::Auto/);

Any idea ? 


I have DBD 1.4.9 and DBIx::Class 0.8 (just upgraded 5 min ago..)
I have the same table running with Class::DBI anf now want to move to DBIC.

-- 
Regards
Rolf Schaufelberger




More information about the DBIx-Class mailing list