X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 086409DC855 for ; Mon, 20 Mar 2006 00:09:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60070-05 for ; Mon, 20 Mar 2006 00:09:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.205]) by postgresql.org (Postfix) with ESMTP id F30719DC81E for ; Mon, 20 Mar 2006 00:09:25 -0400 (AST) Received: by nproxy.gmail.com with SMTP id o25so704113nfa for ; Sun, 19 Mar 2006 20:09:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=googlemail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aBFv85y+q4agQps8eIviIT2dZ3Ux/vZHN76yF18U/qqtu2YUasXIutaVHRhshV3Fa7XedTLYs0CvUtf2Bd+cVV8eEPb4x80YtVbXS40HaE0FNkpVx9cmf8+e3rqyjUx+rQI86BcqxrwuqEEUGdsQQ7EJCKep8+BhKAnmMOn/GKY= Received: by 10.48.239.5 with SMTP id m5mr2656026nfh; Sun, 19 Mar 2006 20:09:24 -0800 (PST) Received: by 10.49.1.16 with HTTP; Sun, 19 Mar 2006 20:09:24 -0800 (PST) Message-ID: <684362e10603192009s28a0afe4m@mail.gmail.com> Date: Mon, 20 Mar 2006 10:09:24 +0600 From: "Markus Bertheau" To: "Christian Paul B. Cosinas" Subject: Re: PostgreSQL Handling of Special Characters Cc: pgsql-sql@postgresql.org In-Reply-To: <001701c64bce$968d59f0$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <200603200114.k2K1EtF29584@candle.pha.pa.us> <001701c64bce$968d59f0$1e21100a@ghwk02002147> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/280 X-Sequence-Number: 24626 2006/3/20, Christian Paul B. Cosinas : > Let's say a character of 150 ASCII code. Which looks like a hypen. > > When I retrieve the value of that field it gives me a question mark > character instead of that 150 ASCII code character. > > What could be the possible reason of this? Perhaps the ODBC driver thinks SQL_ASCII means ASCII and therefore discards all bytes > 127. On PostgreSQL SQL_ASCII really means SQL_ANYTHING, so to speak. Try to use for the database the encoding you really use. Markus Bertheau