From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Ian Barwick <barwick@gmx.net>
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
Date: Thu, 21 Nov 2002 16:27:00 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0211211621170.22779-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <200211211511.26369.barwick@gmx.net>
On Thu, 21 Nov 2002, Ian Barwick wrote:
> On Thursday 21 November 2002 12:38, Achilleus Mantzios wrote:
> > Hi,
> >
> > I noticed that psql on FreeBSD (i checked also fbsd 4.5 with pgsql port
> > installed)
> > does not accept 8bit iso8859-* chars > 128 (where the greek chars are).
> >
> > In linux that works ok, and i can update/insert/select values
> > using greek strings.
> >
> > I know it must be a fbsd/locale issue
>
> It is.
>
> > but it would be nice
> > if someone knew something about it.
>
> Are you able to input Greek characters in the shell you call
> psql from? Do you have any LC_ environment variables set?
I have no LC_*, LANG env vars set.
I can type greek from cat,vim, etc...
Also setting EDITOR to vim
i can \e from psql and write greek chars.
So, maybe it is psql related and not FreeBSD.
Even vi accepts greek in FreeBSD (with their hex representation),
but psql not even seems to allow the 1st bit set of the chars.
(it thinks its a control char).
Could it be FreeBSD readline/locale "C" related??
>
> The FreeBSD handbook has a useful section on this:
>
> http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/l10n.html
>
> HTH
>
> Ian Barwick
> barwick@gmx.net
>
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, barwick@gmx.net, pgsql-general@postgresql.org
Subject: Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
In-Reply-To: <Pine.LNX.4.44.0211211621170.22779-100000@matrix.gatewaynet.com>
References: <200211211511.26369.barwick@gmx.net> <Pine.LNX.4.44.0211211621170.22779-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox