Received: from bastion.solipsys.com (bastion.solipsys.com [209.117.190.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA23849
	for <pgsql-interfaces@hub.org>; Fri, 7 May 1999 15:22:23 -0400 (EDT)
	(envelope-from byronn@solipsys.com)
Received: from solipsys.com ([209.117.190.166])
	by bastion.solipsys.com (8.9.1a/8.9.1) with ESMTP id PAA13089;
	Fri, 7 May 1999 15:21:45 -0400 (EDT)
Sender: byronn@solipsys.com
Message-ID: <37333D87.39666AC1@solipsys.com>
Date: Fri, 07 May 1999 15:22:47 -0400
From: Byron Nikolaidis <byronn@solipsys.com>
X-Mailer: Mozilla 4.5 [en] (X11; U; SunOS 5.7 i86pc)
X-Accept-Language: en
MIME-Version: 1.0
To: Finn Kettner <fk@akf.dk>
CC: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] ODBC boolean conversion and scandinavian characters
References: <199905071912.PAA22509@hub.org>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Content-Transfer-Encoding: 8bit

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