Re: store in bytea

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: store in bytea
Дата
Msg-id 00ea01c12cdd$c34c5a00$b4d210ac@jecw2k1
обсуждение исходный текст
Ответ на store in bytea  ("Ben-Nes Michael" <miki@canaan.co.il>)
Список pgsql-general
> But Ill have to add double slashes and even more importent I will have to
> unescape every binary data going out of the server, which mean in one of
my
> aplication all the Images.
>
> Wont this action be much more heavey then the way I used untill now with
> MySQL (blob) ?
> addslash on insert and ordinary select for output.

Not sure about performance (would be nice if you tried this and reported
back results of MySQL vs PostgreSQL), but last night I found a built-in PHP
function that looks like it would work to convert the escaped binary back to
binary -- see  http://www.php.net/manual/en/function.stripcslashes.php

-- Joe


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

Предыдущее
От: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Дата:
Сообщение: Re: libpq
Следующее
От: Dirk Lutzebaeck
Дата:
Сообщение: backend dies on my aggregate function in 7.1.2