[GENERAL] a problem with single char recoding

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

************************************

In response to

Browse pgsql-general by date

  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