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.