Re: PostgreSQL: Inserting NULL values adds empty string. - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: PostgreSQL: Inserting NULL values adds empty string.
Date
Msg-id 56C1BC21.60100@dream.email.ne.jp
Whole thread Raw
In response to PostgreSQL: Inserting NULL values adds empty string.  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
List pgsql-odbc
Hi,

Aren't the fields date or timestamp?
If so, there is an option to convert from null to empty string.

regards,
Hiroshi Inoue

On 2016/02/14 22:13, Venkatesan, Sekhar wrote:
> Hi Folks,
>
> I am using PostgreSQL 9.4 odbc driver to talk to 9.4 postgreSQL server.
> I see that when inserting NULL values into DB is adding empty  string in the database only in windows.
> The same insert is adding NULL values into database when linux odbc driver is used to connect to linux database.
>   Is there any configuration in odbc driver end or in server to retain the null values or is it a bug?
> If it is not and is an expected behavior, how to fix it in the application?
>
> Thanks,
> Sekhar
>


pgsql-odbc by date:

Previous
From: Dang Minh Huong
Date:
Subject: Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: Degradation of performance when upgrade psqlodbc to 09.03.0400