Thread: bytea and ODBC

bytea and ODBC

From
"Raymond O'Donnell"
Date:
Hi all,

Is it possible to store large-ish binary data in a bytea field via
ODBC? I've been trawling the list archives, and there seems to have
been a limit of 8190 bytes at one time - is that still the case?

I'm trying to do this in a web application with ASP/VBScript and
ADO...any pointers or examples would be appreciated.

Thanks!

--Ray O'Donnell

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------



Re: bytea and ODBC

From
Kenneth Suralta
Date:
Hello,<br /><br /> I have the same problem..<br /><br /> I found out that this is a bug..<br /><a
class="moz-txt-link-freetext"
href="http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?841">http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?841</a><br
/><br/> Is this also in the previous versions of psqlodbc ?<br /><br /> Also, I tried replacing bytea with text, i
thinkit still has the same problem...<br /><br /><br /><br /> Raymond O'Donnell wrote:<br /><blockquote
cite="mid40CA2324.21495.6FA174@localhost"type="cite"><pre wrap="">Hi all,
 

Is it possible to store large-ish binary data in a bytea field via 
ODBC? I've been trawling the list archives, and there seems to have 
been a limit of 8190 bytes at one time - is that still the case?

I'm trying to do this in a web application with ASP/VBScript and 
ADO...any pointers or examples would be appreciated.

Thanks!

--Ray O'Donnell

-------------------------------------------------------------
Raymond O'Donnell     <a class="moz-txt-link-freetext"
href="http://www.galwaycathedral.org/recitals">http://www.galwaycathedral.org/recitals</a>
<a class="moz-txt-link-abbreviated" href="mailto:rod@iol.ie">rod@iol.ie</a>                          Galway Cathedral
Recitals
-------------------------------------------------------------



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to <a
class="moz-txt-link-abbreviated"href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>)
 

 </pre></blockquote><br /><div class="moz-signature">-- <br /><img border="0"
src="cid:part1.08080303.09010701@hq.ntsp.nec.co.jp"/></div>