Re: How to transfer binary data into a BIT VARYING column ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to transfer binary data into a BIT VARYING column ?
Дата
Msg-id 14575.1242746311@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to transfer binary data into a BIT VARYING column ?  (Timothy Madden <terminatorul@gmail.com>)
Ответы Re: How to transfer binary data into a BIT VARYING column ?  (Timothy Madden <terminatorul@gmail.com>)
Список pgsql-odbc
Timothy Madden <terminatorul@gmail.com> writes:
> I have a BIT VARYING(83886080) column in my table and I would like to
> store file attachments
> in it.

Use bytea.

> I would like to use BIT VARYING because it is an ANSI-conformant
> binary type, while bytea and 'lo' are not ANSI SQL.

Considering the nonstandard things you will have to do to get data into
the column, this seems like a pretty silly argument.

            regards, tom lane

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

Предыдущее
От: Timothy Madden
Дата:
Сообщение: How to transfer binary data into a BIT VARYING column ?
Следующее
От: Timothy Madden
Дата:
Сообщение: Re: How can I bind query parameters to variables ?