From: | "Robert Max Kramer" <RobertMax(dot)Kramer(at)gmx(dot)de> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Driver uses always UTF-8? |
Date: | 2005-04-07 18:03:47 |
Message-ID: | 001901c53b9c$2b0f3100$14b2a8c0@rk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-08 03:00:24 | Security of ODBC debug log file leaves something to be desired |
Previous Message | Jerry Lam | 2005-04-07 04:24:38 | How can I configure the postgresql odbc to return 1 row at a time? |