Re: Selecting a constant question

Dann Corbit <dcorbit@connx.com>

From: "Dann Corbit" <DCorbit@connx.com>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Gregory Stark" <stark@enterprisedb.com>, "Martijn van Oosterhout" <kleptog@svana.org>, <pgsql-hackers@postgresql.org>, "Larry McGhaw" <lmcghaw@connx.com>
Date: 2007-06-11T22:54:08Z
Lists: pgsql-hackers
> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
> Sent: Monday, June 11, 2007 3:44 PM
> To: Dann Corbit
> Cc: Tom Lane; Gregory Stark; Martijn van Oosterhout; pgsql-
> hackers@postgresql.org; Larry McGhaw
> Subject: Re: [HACKERS] Selecting a constant question
> 
> Dann Corbit wrote:
> 
> > If the server bound the data as UNICODE, then it will tell me
> > UNICODE(3).  I know how big this will be.
> >
> > In the worst case scenario it will fit in 3*4 = 12 bytes.
> >
> > If the server is built without UNICODE enabled, then it will
definitely
> > fit in 3 bytes.
> 
> Unless it's some other multibyte encoding.  And nowadays, the server
is
> always "unicode enabled".  The stuff sent down the wire is unicode or
> not depending on a configuration parameter.

Even at that, we still know an absolute maximum of 12 bytes.