Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string. - Mailing list pgsql-sql

From Venkatesan, Sekhar
Subject Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.
Date
Msg-id F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com
Whole thread Raw
In response to Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.
Next
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.