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

I want to store a .jpeg file in a table

From

"Inacio dsilva"

Date:

20 May 2002, 07:29:18

<div style="background-color:"><div>hi,</div><div>  <div><font face="Arial" size="2">I'd like to know how to store a
filea table and also which datatype is used for this? I'm using VC++ on windows and SQL ODBC API functions to connect
tothe 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?</font></div><div><font face="Arial" size="2"></font> </div><div><font face="Arial"
size="2">Thanks.</font></div></div></div><brclear="all" /><hr />Send and receive Hotmail on your mobile device: <a
href="http://g.msn.com/1HM303401/38">ClickHere</a><br />

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

From

"Henshall, Stuart - WCP"

Date:

24 May 2002, 07:35:22

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@hotmail.com]
Sent: 20 May 2002 09:27
To: pgsql-odbc@postgresql.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