Re: PostgreSQL+ Beta bug?

[..]
>According to an ODBC related document, the behavior of ODBC
>functions in such case is undefined and it is driver-specific
>if a driver handles this correctly.

OK. If it is driver-specific then why don't allow users to
to use this feature if it is implemented in the server?

>> insert/read data entirely making usage of provided length.
>> Is it implemented like that?
>
>No and how can I implement it ?
>Must I convert '\0' to "|| chr(0) ||" where there's no
>guarantee that it works ?

Why not?

Your statement suggests that parameter values are hard-coded
into SQL statements by ODBC driver. Is that true?

If you encode 0 as "|| chr(0) ||" it will change nothing:
if the server is able to store something after 0 then
it will be stored, otherwise not. If you afraid then
maybe this behaviour can be implemented as an option
to the ODBC data source (like "LF<->CR/LF Conversion")?

Is it much work to add such option?

Best regards,
Bozena Potempa

P.S.
0s in strings are important for some of our customers,
storing very strange things in their old Clipper
applications.