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 852F79DCE39 for ; Sun, 19 Mar 2006 23:21: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 52435-06 for ; Sun, 19 Mar 2006 23:21:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailer.eglobalreach.net (mail.opm.ph [202.124.128.22]) by postgresql.org (Postfix) with ESMTP id E75F09DCE34 for ; Sun, 19 Mar 2006 23:21:08 -0400 (AST) Received: from ghwk02002147 (mailer.eglobalreach.net [127.0.0.1]) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id k2K3L0Q17292; Mon, 20 Mar 2006 11:21:05 +0800 From: "Christian Paul B. Cosinas" To: Cc: "'Christian Paul B. Cosinas'" Subject: PostgreSQL Handling of Special Characters Date: Sun, 19 Mar 2006 19:30:02 -0800 Message-ID: <001701c64bce$968d59f0$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: AcZLu8mblLp4nhrjQQOxPq+Wf8PwcgAEbPcQ X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <200603200114.k2K1EtF29584@candle.pha.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.667 required=5 tests=[AWL=0.667] X-Spam-Score: 0.667 X-Spam-Level: X-Archive-Number: 200603/279 X-Sequence-Number: 24625 Hi to all, I am currently using PostgreSQL 8.0.3 My Database uses SQL_ASCII encoding. I have a program in Visual Basic that connects to PostgreSQL using ODBC Connection through File DSN. I insert a text in one fields of my table. For example, I insert a special character to that field. 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? Is there a setting in the database configuration to understand that such special characters? Please..I really need an answer to this.. Thanks You. I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html