On Apr 2, 2007, at 11:02, jerome moliere wrote:
CREATE TABLE PAITINGS_TBL(painting_id int primary key,painting_data
bytea);
CREATE TABLE ARTISTS_BIO(artist_id int primary key, artist_text_bio
bytea);
in this schema 2 tables with 2 BLOB fields, the first one is simply
the JPEG
while the second is a long text with all the artist bio...
The extendedtype could permit me to change the Cayenne behavior but
for all
bytea fields isn't it ?
No. You can map painting_data to Image and create an ExtendedType to
handle Image. Your artist_text_bio should perhaps be of type text
instead of bytea?
- Tore.
