Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.

It's a C++ application that talks to PostgreSQL DB. I checked the value in database directly.

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Sunday, February 14, 2016 10:19 PM
To: Venkatesan, Sekhar; pgsql-odbc@postgresql.org; pgsql-sql@postgresql.org
Subject: Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.

On 02/14/2016 05:13 AM, Venkatesan, Sekhar wrote:
> Hi Folks,
>
> I am using PostgreSQL 9.4 odbc driver to talk to 9.4 postgreSQL server.

Through what application?

> 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.

How are you determining this?

>   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
>



--
Adrian Klaver
adrian.klaver@aklaver.com