Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E40C3475E4A for ; Thu, 21 Nov 2002 09:12:00 -0500 (EST) Received: from lubitsch.akademie.de (ns.akademie.de [62.165.4.3]) by postgresql.org (Postfix) with ESMTP id 6C2FA475E52 for ; Thu, 21 Nov 2002 09:11:59 -0500 (EST) Received: from [62.165.4.160] (helo=redgrave) by lubitsch.akademie.de with esmtp (Exim 3.33 #2) id 18Es3m-0000fT-00; Thu, 21 Nov 2002 15:12:02 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick Organization: akademie.de To: Achilleus Mantzios Subject: Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars Date: Thu, 21 Nov 2002 15:11:26 +0100 User-Agent: KMail/1.4.3 Cc: pgsql-general@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200211211511.26369.barwick@gmx.net> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/922 X-Sequence-Number: 33343 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