> -----Original Message-----
> From: Bo?ena Potempa [mailto:Bozena.Potempa@otc.pl]
>
> Hiroshi,
>
> > >Which version of PostgreSQL server are you connecting ?
> >>
> >> 7.2.3.
> >
> >I can't your case in 7.2.3 but in 7.2.1 the result is
> > 0 0 0 not 0 1 0.
>
> It is more complicated then I thought.
> I have 2 test installations of PostgreSQL: one on Linux
> and the second one on Windows NT, both 7.2.3 version.
> The Linux installation works with 0 stored in varchar
> field (the test results are as described in my previous
> e-mail). The Windows installation does not support zeroes
> in strings!
Hmm the difference may come from (non-)multibyte mode.
> Now I am not sure which behaviour is correct (and planned
> by PostgreSQL developers).
As far as I see PostgreSQL couldn't handle non-null-terminated
strings correctly.
regards,
Hiroshi Inoue
