| From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
|---|---|
| To: | "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com> |
| Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL: Inserting NULL values adds empty string. |
| Date: | 2016-02-15 11:53:05 |
| Message-ID: | 56C1BC21.60100@dream.email.ne.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc pgsql-sql |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inoue, Hiroshi | 2016-02-15 12:38:44 | Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 |
| Previous Message | Dang Minh Huong | 2016-02-15 09:12:55 | Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Suresh Raja | 2016-02-16 15:41:18 | refer function name by a variable in the function body |
| Previous Message | Adrian Klaver | 2016-02-14 18:36:36 | Re: PostgreSQL: Inserting NULL values adds empty string. |