Storing binary data in a column

Поиск
Список
Период
Сортировка
От Yamini Sharma
Тема Storing binary data in a column
Дата
Msg-id Pine.LNX.4.10.10005171803010.25618-100000@zeus.seepz.w-o-i.com
обсуждение исходный текст
Ответы Re: Storing binary data in a column  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Alex Guryanow
Дата:
Сообщение: lower() for varchar data by creating an index
Следующее
От: Brook Milligan
Дата:
Сообщение: Re: question on update/delete rules on views