From: | Marcin Inkielman <marn(at)wsisiz(dot)edu(dot)pl> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | [GENERAL] a problem with single char recoding |
Date: | 1999-12-17 17:55:38 |
Message-ID: | Pine.LNX.4.21.9912171821480.18960-100000@mi.marnnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
************************************
From | Date | Subject | |
---|---|---|---|
Next Message | admin | 1999-12-17 18:17:40 | making 'like' queries quicker |
Previous Message | Bruce Momjian | 1999-12-17 17:52:44 | Re: [GENERAL] Confirmation of feature of in version 7 |