PLEASE HELP ME!: binary data in text/varchar?

From: Swaminathan Natarajan <swami(at)dcs(dot)uky(dot)edu>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: PLEASE HELP ME!: binary data in text/varchar?
Date: 2001-03-29 20:19:35
Message-ID: Pine.LNX.4.10.10103291507290.31529-100000@mickey.dcs.uky.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there!

I am using pgsql 7.0/ecpg C interface on Redhat 6.1.
Is it possible to store and retrieve fixed length binary data (<100bytes
in length) in text or varchar (or any other data type)? Using ecpg, I want
to "memcpy" from my local variable to a field in the table and back.
Postgresql seems to do a "strcpy" instead. If someone can help me, I
would greatly appreciate it! I checked the archives and examples but found
no relevant articles.

THANKS!!!
Swami.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-29 20:30:08 Re: missing data
Previous Message Peter Eisentraut 2001-03-29 20:07:37 Re: missing data