Re: putting binary data in a char field?

From: Ron Snyder <ron(dot)snyder(at)quovadx(dot)com>
To: 'George Essig' <george_essig(at)yahoo(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: putting binary data in a char field?
Date: 2004-06-19 02:48:13
Message-ID: D486606E7AD20947BDB7E56862E04C39474FAD@cvo1.cvo.roguewave.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> You should also experiment with using a TEXT field and base64
> encoding to insert data and base64 decoding to select data.
> In my experience, this is faster than using a bytea field.
> Certain characters in binary data have to be escaped properly
> before you can insert data. The size and time this takes can
> vary. Base64 encoding is fast and will increase the binary
> string by 1/3.

Hmm, I may give that a try. Thanks,

-ron

Browse pgsql-general by date

  From Date Subject
Next Message Luiz Rafael Culik Guimaraes 2004-06-19 03:55:28 Escape chars
Previous Message Michael Fork 2004-06-19 02:47:21 Current Query from Trigger