| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | "Edwin Quijada" <listas_quijada(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Send a variable 123k |
| Date: | 2004-03-15 18:48:25 |
| Message-ID: | 57AE4848-76B1-11D8-9B11-000D9366F0C4@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edwin Pauli | 2004-03-15 18:49:32 | Re: PostgeSQL problem (server crashed?) |
| Previous Message | Shilong Stanley Yao | 2004-03-15 18:38:05 | Character escape in "CREATE FUNCTION ..." |