> -----Original Message----- > From: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:44 PM > To: Dann Corbit > Cc: Tom Lane; Gregory Stark; Martijn van Oosterhout; pgsql- > [EMAIL PROTECTED]; 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq