Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Ian Barwick <barwick(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
Date: 2002-11-21 14:59:10
Message-ID: Pine.LNX.4.44.0211211650110.22779-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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.

Thats right.

Just a
setenv LANG el_GR.ISO8859-7
did the trick.

However i noticed that ANY LANG value whould do.
libc (or glibc in linux) just need LANG not to be empty.

>
> HTH
>
> Ian Barwick
> barwick(at)gmx(dot)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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-11-21 15:04:34 Re: tcpip connections..
Previous Message Tom Lane 2002-11-21 14:57:10 Re: PostgreSQL compilation with custom table name length

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-11-21 15:26:59 Re: Date trunc in UTC
Previous Message Henshall, Stuart - Design & Print 2002-11-21 14:51:29 Re: help optimise this ?