Re: pgsql-sql-digest V1 #393

> Date: Mon, 25 Oct 1999 16:49:07 -0700 (Pacific Daylight Time)
> From: Andrew Perrin - Demography <aperrin@demog.berkeley.edu>
> Subject: Access and field sizes
>
> Greetings-
>
> I'm in the process of porting a database from Access to postgres, and have
> run into a snag.  The snag involves boolean fields using checkboxes in
> Access forms; they always return a useless Microsoftish error:
>
> The field is too small to accept the amount of data you attempted to add.
> Try inserting or pasting less data.
>
> This happens when a checkbox is clicked to set a boolean value to True,
> but not when it is clicked to set the value back to False.
>
> Does anyone have any experience or idea where to go with this?
>
> Thanks-
> Andy Perrin
>
> - ---------------------------------------------------------------------
> Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
> Department of Demography    -    University of California at Berkeley
> 2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
> http://demog.berkeley.edu/~aperrin --------------------------SEIU1199
>
   Recently I has a little problem with boolean fields in ODBC access to
postgres. The type of field was char. In the ODBC driver configuration there
are a advanced option : "Bool as char". Take a look.

Juarez Rudsatz