I want to store a .jpeg file in a table

From: "Inacio dsilva" <inacio21(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: I want to store a .jpeg file in a table
Date: 2002-05-20 08:26:48
Message-ID: F23ixzukPVJL7KoO0Zy00005adf@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

<html><div style='background-color:'><DIV>hi,</DIV>
<DIV>&nbsp;
<DIV><FONT face=Arial size=2>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 ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Thanks.</FONT></DIV></DIV></div><br clear=all><hr>Send and receive Hotmail on your mobile device: <a href='http://g.msn.com/1HM303401/38'>Click Here</a><br></html>

Attachment Content-Type Size
unknown_filename text/html 744 bytes

Browse pgsql-odbc by date

  From Date Subject
Next Message Vidas Makauskas 2002-05-20 09:50:27 Re: int8 defined as text in MS Access?
Previous Message Jean-Michel POURE 2002-05-20 07:31:31 Re: [HACKERS] UTF-8 safe ascii() function