Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 99BF4476373 for ; Thu, 21 Nov 2002 09:51:53 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id A5AA3476570 for ; Thu, 21 Nov 2002 09:51:42 -0500 (EST) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id gALExBi22953; Thu, 21 Nov 2002 16:59:11 +0200 Date: Thu, 21 Nov 2002 16:59:10 +0200 (EET) From: Achilleus Mantzios To: Ian Barwick Cc: pgsql-general@postgresql.org Subject: Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars In-Reply-To: <200211211511.26369.barwick@gmx.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/926 X-Sequence-Number: 33347 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