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


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]

Reply via email to