[SQL] bytea ,etc.

2002-08-29 Thread Klimov Andrew
Hi , All!   Could someone clarify me  :   When I want to store BLOB's internally in database (for example jpeg ) should I use bytea or OID? Is OID something like BFILE in Oracle 8i? If both are appropriate why I can't use update image set picture=lo_import('Myfile') where image_code='blablab

[SQL] bytea etc.

2002-08-22 Thread Andrew Klimov
Hi , All!   Could someone clarify me  :   When I want to store BLOB's internally in database (for example jpeg ) should I use bytea or OID? Is OID something like BFILE in Oracle 8i?   If both are appropriate for internal BLOB why I can't use   update image set picture=lo_import('Myfile') where imag