hi all!
i have 2 boxes in my local net:
192.168.1.1 - linux 2.2.12/postgres 6.5.3
192.168.1.2 - windows 98+postgres_odbc+MS Access 97
i want use my postgres database in 3 ways:
- via psql,
- with libpq,CGI,HTTP -> MS Explorer on my Win boxe
- with ODBC on MS Access
the problem is that my linux box runs with LATIN2 and Windows
with 1250 charset.
I know that Postgres offers a method of character recoding.
Following docs and hints from this list I configured my Postgres with
apropriate options and this recoding works quite well but....
when I start postmaster and access my database
1. with libpq, CGI: LATIN2 on my browser works fine - OK
2. with ODBC+ACCESS : WIN 1250 - OK
and then I retry it with
3. libpq, CGI, browser - WIN1250 is still there - WRONG
4. psql - has also WIN1250 !!!
when I restart postmaster psql/libpq work fine again
I tryed to connect libpq via lo and eth0 interface with the same result
and my charset.conf is:
------------------------------
BaseCharset iso
RecodeTable iso win iso-win.tab
RecodeTable win iso win-iso.tab
HostCharset 192.168.1.1 iso
HostCharset 192.168.1.2 win
HostCharset localhost iso
------------------------------
i think files iso-win.tab/win-iso.tab are ok.
thanks for any hint...
************************************
Marcin Inkielman
************************************
************
