From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'Nelson Ferreira Junior'" <nelson(at)radix(dot)com(dot)br>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: Large strings |
Date: | 2000-04-18 07:10:49 |
Message-ID: | 1B3D5E532D18D311861A00600865478C70C4B3@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
The generic answer for storing anything larger than the page size is to
use large objects. Set the columns type to oid, and use the setBytes()
method to insert the strings. To retrieve, you can use either the
getBytes() or getBlob() methods.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Nelson Ferreira Junior [mailto:nelson(at)radix(dot)com(dot)br]
Sent: Monday, April 17, 2000 9:10 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] Large strings
Hi,
I have a JDBC aplication that actualy works with Oracle and I am
porting it PostgreSQL. The trouble is that I have some rows with type
"LONG" (in Oracle) where are stored strings with up to 20Kb and
PostgreSQL doesn't hava this type and seems to be impossible to store
strings larger than 8Kb with the types "TEXT" or "VARCHAR".
What can I do ?!?!
thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-04-18 07:12:44 | RE: Large strings |
Previous Message | Matthew Denny | 2000-04-18 05:06:41 | getting OID of INSERTed record in ECPG |