X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1B0B9D1E0FF for ; Wed, 18 Feb 2004 06:10:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82519-07 for ; Wed, 18 Feb 2004 02:10:08 -0400 (AST) Received: from rock.spider.ru (rock.spider.ru [62.183.34.226]) by svr1.postgresql.org (Postfix) with ESMTP id 58CD4D1E0FE for ; Wed, 18 Feb 2004 02:10:06 -0400 (AST) Received: from rock (localhost [127.0.0.1]) by rock (Postfix) with SMTP id 9DC1791377 for ; Wed, 18 Feb 2004 09:09:49 +0300 (MSK) Received: from sad.localnet.ru (sad.localnet.ru [10.0.0.33]) by rock.spider.ru (Postfix) with ESMTP id CAFFC91375 for ; Wed, 18 Feb 2004 09:09:48 +0300 (MSK) Content-Type: text/plain; charset="iso-8859-1" From: sad Organization: IT To: pgsql-sql@postgresql.org Subject: Re: bytea or blobs? Date: Wed, 18 Feb 2004 09:14:29 +0300 User-Agent: KMail/1.4.3 References: <40322E69.30606@Yahoo.com> In-Reply-To: <40322E69.30606@Yahoo.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200402180914.29318.sad@bankir.ru> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/242 X-Sequence-Number: 16932 On Tuesday 17 February 2004 18:08, you wrote: > I'd recommend to let the application convert the binary > data to and from base64, Don't, please don't ! Since you have the good bytea rule to convert so called "binary" data into = so=20 called "text". You have no need another encoding at all. Generally, the problem is to represent zero (0x00) when input/output. Any= =20 other byte might be stored, dumped, input, output without any problem. Then= =20 why to avoid 8bit chars ? Bytea notation rule completely resolve the problem of zeroes. (and also apostrophes :-) naturally)=20