Re: [GENERAL] I have some questions...

2004-08-02 Thread Michal Taborsky
Prabu Subroto wrote: My boss requested that my application is equipped with emoicon (smiley) in the sales report. That's why I need to know, is it possible to save a small image into the postgres? with which data type should I define the column (field)? What do you mean by "equipped with emoicon (s

Re: [GENERAL] I have some questions...

2004-08-02 Thread Csaba Nagy
Prabu, There are a number of approaches to do this: 1) Store your images on the file system of the server and in the data base store only the path to it; 2) Create an icon table, and store your icons as BLOBs in it, then reference them from your reports table. I'm not an expert on BLOBs, so ple

[GENERAL] I have some questions...

2004-08-02 Thread Prabu Subroto
Dear my friends... My boss requested that my application is equipped with emoicon (smiley) in the sales report. That's why I need to know, is it possible to save a small image into the postgres? with which data type should I define the column (field)? I have a currently table, salesreport. Its fi