Honestly I am not sure if this is the right place to post this question of mine.

We are using MYSql compiled with Big5. We had problems inserting images thru our stand-alone application written in C++ so we UUEncode it and saved as Blob. From that stand-alone app we were able to save them and retrieve and display them.

Do I need to do special mapping and stuff or special SQL to UUDencode it using Hibernate? I have tried doing it from java using UUDecode but the image is broken. Do I UUDecode it from Hibernate or SQL? if so how?

Thanks!!!

You will do this yourself. You can either write methods into your class that get and set the image via the UUencoded String (and map the String in your Hibernate mapping files), or you can write your own UserType and use that to convert the image back and forth when Hibernate gets or sets the image. The second way is probably best and has no impact on your domain objects, but it will involve learning to implement UserType.

hth,
Scott

scott,

thanks man.

But after almost a day of doing tests, we found out that the C++ library was the culprit. It can insert and retreive the image correctly. But when we do it thru java, and even from the command line, images are broken.

This encoding problem really sucks... we were able to store and display chinese texts but images cant be stored if the DB is compiled with Big5.

Thanks again

steve