Re: Problem trying to connect to a database with PGACCESS

I think you have to enable multibyte functionality for the postgres daemon,
and I think you have to do this at compile time...
Configuration for postgres (configure) must be done using the following
options:
--enable-locale (to enable the locale support)
--with-mb=encoding ("mb" for multibyte)
(place the multibyte encoding instead of "encoding")

but I don't know if UTF-8 or what kind of unicode encodings are supported
Anyway, I never did this. I use the libpq interface for now, and I handle
the encodings by hand. Postmaster thinks of plain ascii text and through
this I use UTF-8.

See the admin's manual for more details.
Maybe you can also configure the connection using the environment variable
"PGCLIENTENCODING".

Hope I helped a bit.

----- Original Message -----
From: "Fernando de la Fuente Garcia" <f(dot)fuente(at)crue(dot)upm(dot)es>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Friday, March 08, 2002 1:28 PM
Subject: [INTERFACES] Problem trying to connect to a database with PGACCESS

> Hi everybody,
>
> The problem is that I try to use the PGACCESS to connect to a database
> and when I click the open button, it appear the following message:
>
> Error trying to connect to database 'db1' on host localhost.
> PostgreSQL error message: Connection to database failed.
> ERROR: Client encoding UNICODE is not supported
> "
>
> Does anyone know how to solve this problem?
>
> Thanks,
> FER
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>