| From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com>, Raymond <support(at)bigriverinfotech(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Access 97 DB to Postgres Migration Questions |
| Date: | 2003-07-18 17:11:49 |
| Message-ID: | 20030718171149.3046.qmail@web13402.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> On Friday 18 Jul 2003 4:50 am, Raymond wrote:
> > 2) Is an ODBC type conversion table available for
> Access to Postgres?
>
> They match up pretty much as you would expect
> int4=>long integer etc. One
> thing to watch out for is booleans - come through as
> 0/-1 in Access.
>
> Richard Huxton
I'm dealing with this specific issue for the first
time. How do you suggest dealing with the boolean
incompatibility issue? I can't seem to make
checkboxes work; but I want to keep the pgsql boolean
datatype. Is there a way to change the value input by
checkboxes? Or do I have to go with the text input of
T, F, Y or N?
Thanks,
Andrew Gould
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Corey W. Gibbs | 2003-07-18 17:38:55 | Re: Access 97 DB to Postgres Migration Questions |
| Previous Message | Vernon Smith | 2003-07-18 17:11:01 | Re: (Urgent) Regarding double byte support |