Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
To: "Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>,
 "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>,
 "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
References: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
 <56C0AFEF.70103@aklaver.com>
 <F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <56C0C934.7030403@aklaver.com>
Date: Sun, 14 Feb 2016 10:36:36 -0800
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: <F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-odbc-owner@postgresql.org

On 02/14/2016 10:08 AM, Venkatesan, Sekhar wrote:
> It's a C++ application that talks to PostgreSQL DB. I checked the value in database directly.

Just notice this has been cross-posted to --sql, it is generally 
considered good etiquette to not do that.

What exact version of psqlodbc are you using?

Does the C++ application you mention run on both Linux and Windows?

Or to put it another way, what is the program flow that gets the data 
into the database from Windows versus Linux?

Also are we talking about one Postgres database, or one on Windows and 
one on Linux?

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