X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 32A2ED7D0F for ; Fri, 9 Sep 2005 03:55:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84582-02 for ; Fri, 9 Sep 2005 06:55:30 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id C1AD9D7851 for ; Fri, 9 Sep 2005 03:55:30 -0300 (ADT) Received: from [172.16.1.188] glaesema [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux via secured & encrypted transport (TLS); Fri, 09 Sep 2005 00:55:22 -0600 In-Reply-To: <432126FE.8070805@bankir.ru> References: <20050908181850.G1104@ganymede.hub.org> <432126FE.8070805@bankir.ru> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <6E4BFE76-9B75-4309-B993-CF0D5F7CAC2E@myrealbox.com> Cc: postgresql sql list Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: a "catch all" type ... such a thing? Date: Fri, 9 Sep 2005 15:55:16 +0900 To: "Eugene E." X-Mailer: Apple Mail (2.734) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[AWL=0.024] X-Spam-Level: X-Archive-Number: 200509/102 X-Sequence-Number: 22649 On Sep 9, 2005, at 3:09 PM, Eugene E. wrote: > Marc G. Fournier wrote: > >> Are there any data types that can hold pretty much any type of >> character? UTF-16 isn't supported (or its missing from teh docs), >> and UTF-8 doesn't appear to have a big enough range ... >> > > PLEASE Note: type of caracter is generally not a matter of _datatype_ That said, perhaps BYTEA would work. Not exactly the same as some kind of text string though, as you could only use the BYTEA functions for data manipulation. The SQLASCII encoding is *very* accepting, but has its own issues, which a look in the archives will provide more info. Michael Glaesemann grzm myrealbox com