Hi,
I have a natie postgresql (7.4.1) query which encodes a byte[] column into base64 as follows:

"Select encode(a.artist_photo, 'base64') from artistimagestbl a where a.artistimage_id=" + artistimage_id;

My question is, is there any way I can specify in my hbm.xml map that the artist_photo column should be encoded a base64 without having to specify a native query?

regards


Andrew

Ok,
what i mean is something like:

<property name="ArtistPhoto" column="artist_photo" type="binary" decode/encode="base64"/>

Do we have the ability to do something like that in Hibernate? If not, could it be implemented!? Make sense?

many thanks

Andrew