Re: Send a variable 123k - Mailing list pgsql-general

From Jeff
Subject Re: Send a variable 123k
Date
Msg-id 57AE4848-76B1-11D8-9B11-000D9366F0C4@torgo.978.org
Whole thread Raw
In response to Send a variable 123k  ("Edwin Quijada" <listas_quijada@hotmail.com>)
List pgsql-general
On Mar 15, 2004, at 11:57 AM, Edwin Quijada wrote:

> I need to store a picture into my DB. I am converting this into text
> Base64 and store it into text field. Everything looked fine but when I
> did the insert I got an error about pqread() and this was
> disconnected. Seem a text so big it is not supported for pqread().

well. it SHOULD support text that big.  Was there anything in the log?

Also, you may want to consider bytea instead of base64 stored in a text.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


pgsql-general by date:

Previous
From: Shilong Stanley Yao
Date:
Subject: Character escape in "CREATE FUNCTION ..."
Next
From: Edwin Pauli
Date:
Subject: Re: PostgeSQL problem (server crashed?)