Community
Participate
Working Groups
Created attachment 276881 [details] CLOB data stored in database Hi, We are using Rich Text Editor to input texts , tables and Images and the Rich Text editor is having a provision to import files which also will be having texts,tables and embedded images and on saving the details Rich Text editor is csaving the image part as encoded base64 images and we are saving the same in CLOB in database.While generating the BIRT report the CLOB data which has texts , tables and images , only images are not displaying in report as the same only is encoded in base64 other details text and tables are displaying in report as the same is not encoded in case64 .Request to please check the same and do the needful Regarkds Arun
CLOB is not for images. Use a BLOB for storing images in your database. As a workaround, you could do the base64 decoding inside a BIRT script to create a Java byte array, then use a dynamic image. Obviously you need a second column in your database to specify if the CLOB content means text or a base64-encoded image. Use this column to show/hide the Dynamic Text item or the Image item.