Re: PostgreSQL: Inserting NULL values adds empty string.

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
>