Обсуждение: ODBC boolean conversion and scandinavian characters

Hi there.

I'm using Postgres 6.3.2 with the ODBC driver, and have come across a 
few oddities when exporting tables from Access97 to Postgres:

1. boolean fields are converted to type bpchar instead of type bool.
2. scandinavian characters (That is 'æøåÆØÅ') are converted to '_'.

Is this the normal behavior?? I can't seem to find anything in the 
documentation/faq about these issues. Is there any way I can help the 
two inconveniencies other that hard manual work :-).

Yours faithfully.
Finn Kettner.

Den  7 May 99 kl. 21:12 skrev Finn Kettner om [INTERFACES] ODBC 
boolean conversio:

Dohh. Sorry about my posting, 2 minutes in the configuration manual 
and the first problem was solved (don't map bools as char). I simply 
don't know how I could miss that one in the first place, sorry!!!

> 1. boolean fields are converted to type bpchar instead of type bool.

Well one down, one to go, this one I still haven't solved, so if any 
of you have any ideas....

> 2. scandinavian characters (That is 'æøåÆØÅ') are converted to '_'.

Yours faithfully.
Finn Kettner.

Finn Kettner wrote:

> Hi there.
>
> I'm using Postgres 6.3.2 with the ODBC driver, and have come across a
> few oddities when exporting tables from Access97 to Postgres:
>
> 1. boolean fields are converted to type bpchar instead of type bool.

Check the driver settings.  There is an option to map booleans to either
bit or char.  It is probably set to char.

>
> 2. scandinavian characters (That is 'æøåÆØÅ') are converted to '_'.
>

Don't know about this one.


Byron