X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 191B79FB30C for ; Fri, 4 Aug 2006 17:02:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 06239-10 for ; Fri, 4 Aug 2006 20:02:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc3-s28.bay0.hotmail.com (bay0-omc3-s28.bay0.hotmail.com [65.54.246.228]) by postgresql.org (Postfix) with ESMTP id 1E76A9FB301 for ; Fri, 4 Aug 2006 17:02:31 -0300 (ADT) Received: from hotmail.com ([65.54.162.23]) by bay0-omc3-s28.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 4 Aug 2006 13:02:30 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 4 Aug 2006 13:02:30 -0700 Message-ID: Received: from 65.54.162.200 by by108fd.bay108.hotmail.msn.com with HTTP; Fri, 04 Aug 2006 20:02:26 GMT X-Originating-IP: [64.237.4.140] X-Originating-Email: [amushayeed@hotmail.com] X-Sender: amushayeed@hotmail.com From: "Abu Mushayeed" To: pgsql-admin@postgresql.org Subject: UTF8 question Date: Fri, 04 Aug 2006 13:02:26 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 04 Aug 2006 20:02:30.0123 (UTC) FILETIME=[EA8C93B0:01C6B800] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.907 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200608/49 X-Sequence-Number: 22593 Hello, If I want data to come out from my DB which is UTF8 into LATIN1 or SQL_ASCII. How do I do it. How do I handle the "ô" characters. WIll it come out the same as in the DB? Thanks Abu