Обсуждение: 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