UNICODE characters vs. BINARY - Mailing list pgsql-hackers

From Gunther Schadow
Subject UNICODE characters vs. BINARY
Date
Msg-id 38528AD6.B186C0B7@aurora.rg.iupui.edu
Whole thread Raw
List pgsql-hackers
Hi,

it seems to me that it's not quite clear whether pgsql makes
a consistent difference between byte and char, and if so, if
there is any way to store a small-sized array of bytes without
going right to a BLOB. If you interface pgsql with Java/JDBC
the support of UNICODE (16 bit per char) is quite essential to
avoid surprises.

A related question is whether we could support some more
standard names for data types (e.g., BIGINT, SMALLINT, etc.)
But I'm not sure there is really any standard. I would be
willing to work a little on these data types but I'd need
someone to hint me on who else is doing stuff and, if possible,
where to look first (and what known mistakes to avoid.)

regards
-Gunther


--
Gunther_Schadow-------------------------------http://aurora.rg.iupui.edu
Regenstrief Institute for Health Care
1050 Wishard Blvd., Indianapolis IN 46202, Phone: (317) 630 7960
schadow@aurora.rg.iupui.edu------------------#include <usual/disclaimer>
Attachment

pgsql-hackers by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] LONG
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: [PATCHES] pg_dump primary keys