I want to store image files into monetdb sql server. I think there are two
approaches to do it:
the first one is to store the file's full path in a column with varchar
type, the second one is to store the image data in a column with blob type.
I don't want to see a lot of small image files in the directory, so I choose
the second approach.
After reading the monetdb manual, I find some examples like this:
sql> insert into t1 values (1, blob '012');
I think this is not enough. I also try to …
[View More]use odbc api to store binary data
into monetdb, but failed.
So please help me to write the blob data into monetdb, as well as the read
operation. Maybe there are other ways I don't know, please tell me, thanks!
[View Less]
query:
select extract(second from '2009-07-24 16:03:35.0000');
result : 0.00
could you please tell me why the result is zero??? and how can i get more spesific result???
Akses email lebih cepat. Yahoo! menyarankan Anda meng-upgrade browser ke Internet Explorer 8 baru yang dioptimalkan untuk Yahoo! Dapatkan di sini!
http://downloads.yahoo.com/id/internetexplorer
