Driver uses always UTF-8? - Mailing list pgsql-odbc

From Robert Max Kramer
Subject Driver uses always UTF-8?
Date
Msg-id 001901c53b9c$2b0f3100$14b2a8c0@rk
Whole thread Raw
In response to PGAPI_Columns() does not follow search path  ("Ken Faiczak" <kfaiczak@sandvine.com>)
Responses Re: Driver uses always UTF-8?
List pgsql-odbc
Hello,

I want to substitue an existing DB2 to PG 8 and got a Problem. Much of our
applications are written in Cobol and are using ODBC Interface to get data.
With DB2, that runs.

The Problem is now in my Test Environment when I connect to PG that I can
read everything well except german umlaute (ä, ü,...). I always get "?" and
not the umlaut.
My database's encoding is LATIN1. Windows Codepage tried with 850 and 1252.

When I read with client-side encoding UNICODE, I got the umlaute, but I
cannot write them to PG. Wirte statements like INSERTs work with LATIN1
encoding.

But something that never worked is, when I send a statement which should
return values with umlaute in it and which have umlaute in a WHERE-clause.
like: SELECT...FROM...WHERE text='ä';

I have tested it under WinNT as well as under WinXP. Same problem. Does
anyone have an idea?

Greetings,
R M Kramer


pgsql-odbc by date:

Previous
From: "Jerry Lam"
Date:
Subject: How can I configure the postgresql odbc to return 1 row at a time?
Next
From: yue chen
Date:
Subject: Problem with download