[SQL] BLOB

2001-05-13 Thread Antti Linno
Hallo. I was just searching documents how to define BLOB in postgres and couldn't find any hints. Could somebody enlighten me? Postgres is 7.0.3. I need to insert into DB text field more than 8000 symbols and there is no way, I can upgrade postgres to 7.1, so only way I see it's possible, is by d

Re: [SQL] Blob Upload

2000-11-21 Thread Aristeu Gil Alves Junior
D]> To: Aristeu Gil Alves Junior <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 21, 2000 11:42 AM Subject: Re: [SQL] Blob Upload >Do you mean VARCHAR[30] or VARCHAR(30)?? >I think you're creating an array of chars... >but what you want is just a VARCHA

Re: [SQL] Blob Upload

2000-11-21 Thread Keith Wong
Do you mean VARCHAR[30] or VARCHAR(30)?? I think you're creating an array of chars... but what you want is just a VARCHAR type with 30 characters... It may explain the array error you are getting. Keith At 11:07 AM 21/11/2000 -0200, Aristeu Gil Alves Junior wrote: >I´m trying to upload a gif im

[SQL] Blob Upload

2000-11-21 Thread Aristeu Gil Alves Junior
I´m trying to upload a gif image from a web interface (apache/php) without success. I´m using the input type ="file". Have someone already made this work? And even when I try to upload from the SQL interface of Tkl PgAccess... : The table: CREATE TABLEimages (name VARCHAR[30] , img OID); SQ