Re: PostgreSQL+ Beta bug?

>From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
>Sent: Saturday, November 16, 2002 12:38 AM

[..]
>As long as you are using text(char or varchar) type, you can't
>store strings other than null terminated ones.
>Please use BYTEA type instead and bind the parameter using
>SQL_C_BINARY and SQL_VARBINARY.

But that's true only in ODBC, so I think it _is_ a bug
in ODBC driver. It is perfectly possible to store 0 in
varchar or char fields. Please try from psql:

INSERT INTO t values (chr(0)||chr(1)||chr(0));
and then check:
select ascii(substring(fc,1,1)) from t; - 0
select ascii(substring(fc,2,1)) from t; - 1
select ascii(substring(fc,3,1)) from t; - 0

Works perfect!

What do you think about this?

Best reagards,
Bozena Potempa