pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
5+ messages / 3 participants
[nested] [flat]
* psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
@ 2002-11-21 11:38 Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 14:11 ` Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Ian Barwick <barwick@gmx.net>
2002-11-21 22:38 ` Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Manuel Sugawara <masm@fciencias.unam.mx>
0 siblings, 2 replies; 5+ messages in thread
From: Achilleus Mantzios @ 2002-11-21 11:38 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-general@postgresql.org
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, but it would be nice
if someone knew something about it.
==================================================================
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
2002-11-21 11:38 psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
@ 2002-11-21 14:11 ` Ian Barwick <barwick@gmx.net>
2002-11-21 14:27 ` Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 14:59 ` Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 2 replies; 5+ messages in thread
From: Ian Barwick @ 2002-11-21 14:11 UTC (permalink / raw)
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-general@postgresql.org
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?
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
2002-11-21 11:38 psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 14:11 ` Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Ian Barwick <barwick@gmx.net>
@ 2002-11-21 14:27 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 0 replies; 5+ messages in thread
From: Achilleus Mantzios @ 2002-11-21 14:27 UTC (permalink / raw)
To: Ian Barwick <barwick@gmx.net>; +Cc: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
2002-11-21 11:38 psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 14:11 ` Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Ian Barwick <barwick@gmx.net>
@ 2002-11-21 14:59 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 0 replies; 5+ messages in thread
From: Achilleus Mantzios @ 2002-11-21 14:59 UTC (permalink / raw)
To: Ian Barwick <barwick@gmx.net>; +Cc: pgsql-general@postgresql.org
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@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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
2002-11-21 11:38 psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
@ 2002-11-21 22:38 ` Manuel Sugawara <masm@fciencias.unam.mx>
1 sibling, 0 replies; 5+ messages in thread
From: Manuel Sugawara @ 2002-11-21 22:38 UTC (permalink / raw)
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-sql; pgsql-general@postgresql.org
Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> 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, but it would be nice
> if someone knew something about it.
If pgsql is using readline adding
set meta-flag on
set convert-meta off
set output-meta on
to /etc/inputrc or ~/.inputrc could help. See readline(3).
Regards,
Manuel.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-11-21 22:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-21 11:38 psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 14:11 ` Ian Barwick <barwick@gmx.net>
2002-11-21 14:27 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 14:59 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-11-21 22:38 ` Manuel Sugawara <masm@fciencias.unam.mx>
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