pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: [INTERFACES] ODBC boolean conversion and scandinavian characters 3+ messages / 2 participants [nested] [flat]
* ODBC boolean conversion and scandinavian characters @ 1999-05-07 20:12 Finn Kettner <fk@akf.dk> 1999-05-07 19:22 ` Re: [INTERFACES] ODBC boolean conversion and scandinavian characters Byron Nikolaidis <byronn@solipsys.com> 1999-05-07 20:19 ` Re: [INTERFACES] ODBC boolean conversion and scandinavian charac Finn Kettner <fk@akf.dk> 0 siblings, 2 replies; 3+ messages in thread From: Finn Kettner @ 1999-05-07 20:12 UTC (permalink / raw) To: pgsql-interfaces@hub.org 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC boolean conversion and scandinavian characters 1999-05-07 20:12 ODBC boolean conversion and scandinavian characters Finn Kettner <fk@akf.dk> @ 1999-05-07 19:22 ` Byron Nikolaidis <byronn@solipsys.com> 1 sibling, 0 replies; 3+ messages in thread From: Byron Nikolaidis @ 1999-05-07 19:22 UTC (permalink / raw) To: Finn Kettner <fk@akf.dk>; +Cc: pgsql-interfaces@hub.org 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC boolean conversion and scandinavian charac 1999-05-07 20:12 ODBC boolean conversion and scandinavian characters Finn Kettner <fk@akf.dk> @ 1999-05-07 20:19 ` Finn Kettner <fk@akf.dk> 1 sibling, 0 replies; 3+ messages in thread From: Finn Kettner @ 1999-05-07 20:19 UTC (permalink / raw) To: pgsql-interfaces@hub.org 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-05-07 20:19 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-05-07 20:12 ODBC boolean conversion and scandinavian characters Finn Kettner <fk@akf.dk> 1999-05-07 19:22 ` Byron Nikolaidis <byronn@solipsys.com> 1999-05-07 20:19 ` Re: [INTERFACES] ODBC boolean conversion and scandinavian charac Finn Kettner <fk@akf.dk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox