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 EEF749DC89A for ; Mon, 20 Mar 2006 01:39:13 -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 68613-08 for ; Mon, 20 Mar 2006 01:39:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailer.eglobalreach.net (mailer.eglobalreach.net [202.124.128.22]) by postgresql.org (Postfix) with ESMTP id A9E489DC88D for ; Mon, 20 Mar 2006 01:39:10 -0400 (AST) Received: from ghwk02002147 (mailer.eglobalreach.net [127.0.0.1]) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id k2K5d1t21613; Mon, 20 Mar 2006 13:39:06 +0800 From: "Christian Paul B. Cosinas" To: "'Markus Bertheau'" Cc: Subject: Re: PostgreSQL Handling of Special Characters Date: Sun, 19 Mar 2006 21:48:03 -0800 Message-ID: <002701c64be1$de30c220$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcZL1BTBeT0YdNNoTaKGPFmaJjnT2QADbSAA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <684362e10603192009s28a0afe4m@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.568 required=5 tests=[AWL=0.568] X-Spam-Score: 0.568 X-Spam-Level: X-Archive-Number: 200603/281 X-Sequence-Number: 24627 Hi Markus, Can you please elaborate more on this. I'm really lost. Thank You So Much. -----Original Message----- From: Markus Bertheau [mailto:mbertheau.pg@googlemail.com] Sent: Sunday, March 19, 2006 8:09 PM To: Christian Paul B. Cosinas Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] PostgreSQL Handling of Special Characters 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 I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html