| From: | Avery Payne <apayne(at)pcfruit(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: New release of psqODBC? |
| Date: | 2006-10-12 18:10:10 |
| Message-ID: | 452E8502.2080908@pcfruit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">Dave Page wrote:
</font></pre>
<blockquote
style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;"><font
face="Arial, Helvetica, sans-serif"><tt> </tt><tt></tt></font>
<blockquote
style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;">
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">-----Original Message-----
</font></pre>
<font face="Arial, Helvetica, sans-serif"><tt>From: Hiroshi Saito [<a
rel="nofollow" href="mailto:z-saito">mailto:z-saito</a> ( at ) guitar
( dot ) ocn ( dot ) ne ( dot ) jp] </tt><tt>Sent: 10 October 2006
17:19
</tt></font>
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">To: Dave Page; Hiroshi Inoue
Cc: pgsql-odbc ( at ) postgresql ( dot ) org
Subject: Re: [ODBC] New release of psqODBC?
</font></pre>
<blockquote
style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;"><font
face="Arial, Helvetica, sans-serif"><tt>From: Dave Page </tt><tt>I've
never saw a reply to this question - can you comment please?
</tt></font></blockquote>
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">Hi Dave.
</font></pre>
<font face="Arial, Helvetica, sans-serif"><tt>As for me, tests of
08.02.0102 of the present version is not </tt><tt>completed yet.
</tt></font>
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">1.) *nix build for iODBC and unixODBC
2.) *nix build 64bit mode.
3.) MS build for VS2005.
4.) MS build 64bit mode.
5.) MSDTC...
</font></pre>
<font face="Arial, Helvetica, sans-serif"><tt>Someone can help
them. However, it was not necessarily </tt><tt>decided that they </tt><tt>would
be the specifications still opened wide.
</tt></font><font face="Arial, Helvetica, sans-serif"><tt>Inoue-san
has included them and correcting the some bugs. </tt><tt>It seems that
it becomes the Version 08.02.0103 edition. </tt></font></blockquote>
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">Well, we should really gather some of the bug fixes from 08.02.0100 into
an 08.02.0200 release ready for inclusion with pgInstaller. We can
always add further improvements in later versions.
</font></pre>
<blockquote
style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;">
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">However, Inoue-san is very busy now....
</font></pre>
</blockquote>
</blockquote>
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">>Sorry for the late answer.
>Unfortunately I can't solve the problems reported by Avery or Andrus yet.
>Anyway I would commit the changes in a day or 2.
>regards,
>Hiroshi Inoue
</font><font><font face="Arial, Helvetica, sans-serif">
Don't wait for me,</font></font> <font
face="Arial, Helvetica, sans-serif">the empty date issue is about as resolved as it will get. I've dug a little deeper into
ODBC and it seems that ODBC has no concept of "empty dates", so there really isn't a way to get the
driver to represent NULLs as empties when going PostgreSQL->ODBC->FoxPro. However, converting
empties to NULL is a very practical approach and will be useful to several people. At least it works for
FoxPro->ODBC->PostgreSQL, and that solves all kinds of problems right there. I would be so bold as
to even suggest that it become a default behavior in the driver, silently converting "empty dates" from
Microsoft data sources into NULL; this appears to be the default behavior for MS Access as well,
so I doubt it will cause issues.
</font></pre>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitriy Ivanov | 2006-10-13 06:41:49 | Re: Representing Empty DATE values as NULL |
| Previous Message | Avery Payne | 2006-10-12 17:22:29 | Re: Representing Empty DATE values as NULL |