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

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