Re: PostgreSQL with Centura Team Developer

"J\xFCrgen G. Mischke" wrote:
>
> Hello,
>
> I've some problems with the PostgreSQL-ODBC-driver and Centura Team
> Developer 1.5.1. The connection is ok and a lot of thinks work well. There
> are two datatypes which make some trouble.
>
> 1. Date/Time Values: If  I set a bindvariable to a value like = 2001-02-02
> Postgres take the current Date.??
>

I heard of it from a Centura user and found the cause.
The fix would be in the next release 7.01.0007(?).

> 2. If I set a long-value Postgres don't recognize it. Ex. : Set MyValue =
> '.... String with length 1000 .....', in the OCBD-Log file I see only some
> bytes (and the database too)
>
> For testing I create a table "test_int" with some int's, floats and some
> char,varchar and text() fields.
>

What is the table definition especially for tvarchar, tchar
and tlong ? As long as I see the sqllog.log, the size of text
input is 20. Could centura handle a string bigger than 254 bytes ?

regards,
Hiroshi Inoue