agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Inoue, Hiroshi <h-inoue@dream.email.ne.jp>
To: Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
Cc: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
Date: Mon, 15 Feb 2016 20:53:05 +0900
Message-ID: <56C1BC21.60100@dream.email.ne.jp> (raw)
In-Reply-To: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
References: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-odbc>

Hi,

Aren't the fields date or timestamp?
If so, there is an option to convert from null to empty string.

regards,
Hiroshi Inoue

On 2016/02/14 22:13, Venkatesan, Sekhar wrote:
> Hi Folks,
>
> I am using PostgreSQL 9.4 odbc driver to talk to 9.4 postgreSQL server.
> 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.
>   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
>


-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

view thread (6+ messages)

Message-ID: <56C1BC21.60100@dream.email.ne.jp>
Permalink:  ../56C1BC21.60100@dream.email.ne.jp/
Also on:    postgresql.org/message-id/56C1BC21.60100@dream.email.ne.jp

reply

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: h-inoue@dream.email.ne.jp, sekhar.venkatesan@emc.com, pgsql-odbc@postgresql.org
  Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
  In-Reply-To: <56C1BC21.60100@dream.email.ne.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox