From: Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
To: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
Date: Sun, 14 Feb 2016 18:08:54 +0000
Message-ID: <F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com> (raw)
In-Reply-To: <56C0AFEF.70103@aklaver.com>
References: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
<56C0AFEF.70103@aklaver.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-odbc>
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
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sekhar.venkatesan@emc.com, adrian.klaver@aklaver.com, pgsql-odbc@postgresql.org
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
In-Reply-To: <F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox