Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 96CBA632681 for ; Thu, 8 Jan 2009 18:45:11 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05105-07 for ; Thu, 8 Jan 2009 18:45:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail12.svc.cra.dublin.eircom.net (mail12.svc.cra.dublin.eircom.net [159.134.118.28]) by mail.postgresql.org (Postfix) with SMTP id 30E11632673 for ; Thu, 8 Jan 2009 18:45:07 -0400 (AST) Received: (qmail 56118 messnum 1802314 invoked from network[86.45.245.46/86-45-245-46-dynamic.b-ras3.mvw.galway.eircom.net]); 8 Jan 2009 22:45:04 -0000 Received: from 86-45-245-46-dynamic.b-ras3.mvw.galway.eircom.net (HELO ?127.0.0.1?) (86.45.245.46) by mail12.svc.cra.dublin.eircom.net (qp 56118) with SMTP; 8 Jan 2009 22:45:04 -0000 Message-ID: <496681F1.7070309@iol.ie> Date: Thu, 08 Jan 2009 22:45:05 +0000 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: kulmacet101@kulmacet.com CC: pgsql-php Subject: Re: Correct Encoding References: In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Antivirus: avast! (VPS 090108-0, 08/01/2009), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/2 X-Sequence-Number: 3957 On 08/01/2009 22:41, kulmacet101@kulmacet.com wrote: > I am starting a new project using PHP and Postgres. I recently bumped into > an issue with Postgresql & PHP encoding (It's still a mess). > Could some one recommend what encoding to use for the database that > integrates easily with PHP? I use UTF8 at the server and LATIN9 at the client, as I need to store characters with fádas (accents in Irish). Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------