Re: 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(dot)klaver(at)aklaver(dot)com]
Sent: Sunday, February 14, 2016 10:19 PM
To: Venkatesan, Sekhar; pgsql-odbc(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com