Received: from mail.net.uni-c.dk (mail.net.uni-c.dk [130.226.1.3])
	by hub.org (8.9.3/8.9.3) with SMTP id PAA22509
	for <pgsql-interfaces@hub.org>; Fri, 7 May 1999 15:12:36 -0400 (EDT)
	(envelope-from fk@akf.dk)
Message-Id: <199905071912.PAA22509@hub.org>
Received: (qmail 75766 invoked from network); 7 May 1999 19:12:35 -0000
Received: from mail.akf.dk (HELO AKF.DK) (130.226.251.9)
	by mail.net.uni-c.dk with SMTP; 7 May 1999 19:12:35 -0000
Received: from POST/SpoolDir by AKF.DK (Mercury 1.40);
    7 May 99 21:12:34
Received: from SpoolDir by POST (Mercury 1.40); 7 May 99 21:12:17
From: "Finn Kettner" <fk@akf.dk>
Organization: AKF
To: pgsql-interfaces@hub.org
Date: Fri, 7 May 1999 21:12:10 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: 8BIT
Comments: Sender has elected to use 8-bit data in this message.
	If problems arise, refer to postmaster at sender's site.
Subject: ODBC boolean conversion and scandinavian characters
X-Confirm-Reading-To: "Finn Kettner" <fk@akf.dk>
X-pmrqc: 1
Priority: normal

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.