Storing binary data in a column

From: Yamini Sharma <yamini(at)w-o-i(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Storing binary data in a column
Date: 2000-05-17 12:43:47
Message-ID: Pine.LNX.4.10.10005171803010.25618-100000@zeus.seepz.w-o-i.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

I want to know, how to store binary data in a table, (varchar,
text etc do not work if the data contains nulls embeded in it).

The data type i would like to store is unsigned char *, and it may have
nulls or any other special charecters in it.
INSERT statement works by escaping the special chars using \, but i
could not retreive the results using libpq. The values terminates on a
'\0' character. Is there any other datatype which may be used to store a
binary data string.

Please reply to my email-id as i am not a member of the list.

regards,
Yamini.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard J Kuhns 2000-05-17 13:50:27 Re: Question about databases in alternate locations...
Previous Message Alex Guryanow 2000-05-17 07:51:49 lower() for varchar data by creating an index