On Tuesday 16 May 2006 10:57, Andy Jefferson wrote:
> > I'm not sure there's a good reason that "char" isn't returned as
> > Types.CHAR, but you definitely want to be using bpchar as the default
> > mapping for Types.CHAR.
>
> Thanks for the reply Kris. Only one question. Has "bpchar" existed in
> Postgresql for some time (e.g versions 7.0 onwards) or is it recent ? We
> (JPOX) need to support many versions of Postgresql and I don't want to
> change historical support here.
Also, I cannot do bpchar(100) whereas I can do char(100) ... the precision
returned by getTypeInfo is limited to 9 for bpchar whereas is 65000 for char.
--
Andy