Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB7LdFm07316 for ; Fri, 7 Dec 2001 16:39:15 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fB7LF3444732 for pgsql-sql@postgresql.org; Fri, 7 Dec 2001 16:15:03 -0500 (EST) (envelope-from news) From: jnichols@traxsis.com (Jonathan Nichols) X-Newsgroups: comp.databases.postgresql.sql Subject: Variable Length Binary String (not large) Date: 7 Dec 2001 13:14:59 -0800 Organization: http://groups.google.com/ Lines: 13 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200112/100 X-Sequence-Number: 5923 Hello, Can anyone recommend to me the best way to store a variable length binary string, that isn't larger than the 8192 byte limit for non-large objects?? It seems to me that using BLOBs might be overkill with too much complexity. However, there doesn't seem to be a binary string type in postgres that is meant for small binary strings. I have tried to use normal character strings, but it gets screwed up because of non-printable characters. Any suggestions?? thanks, jon