Skip site navigation (1) Skip section navigation (2)

Re: I want to store a .jpeg file in a table

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Inacio dsilva' <inacio21(at)hotmail(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: I want to store a .jpeg file in a table
Date: 2002-05-24 08:29:17
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748B5@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,
	In the ODBC driver options there is a setting for Max LongVarChar.
Try increasing this:)
hth,
- Stuart

-----Original Message-----
From: Inacio dsilva [mailto:inacio21(at)hotmail(dot)com]
Sent: 20 May 2002 09:27
To: pgsql-odbc(at)postgresql(dot)org
Subject: I want to store a .jpeg file in a table


hi,
  
I'd like to know how to store a file a table and also which datatype is used
for this? I'm using VC++ on windows and SQL ODBC API functions to connect to
the database and get information. I have tried using the datatype "bytea"
but this has a size limitation of 8190 characters. In MS Access and SQL 7.0
there are datatypes of type SQL_LONGVARBINARY. Is there a similar datatype
in postgresql ?
 
Thanks.



Send and receive Hotmail on your mobile device: Click Here

pgsql-odbc by date

Next:From: Kristis MakrisDate: 2002-05-24 17:36:06
Subject: Re: Compiler warninnoop
Previous:From: Hiroshi InoueDate: 2002-05-24 02:08:20
Subject: Re: Compiler warnings in current code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group