Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B61A89FA4B4 for ; Thu, 21 Dec 2006 15:40:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 75101-04 for ; Thu, 21 Dec 2006 15:40:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail21.bluewin.ch (mail21.bluewin.ch [195.186.18.66]) by postgresql.org (Postfix) with ESMTP id D82D69FA48F for ; Thu, 21 Dec 2006 15:40:02 -0400 (AST) Received: from [192.168.1.74] (83.78.107.39) by mail21.bluewin.ch (Bluewin 7.3.118) id 457D6CB200331926 for pgsql-admin@postgresql.org; Thu, 21 Dec 2006 19:40:01 +0000 From: Ivo Rossacher To: pgsql-admin@postgresql.org Subject: Re: Character codification Date: Thu, 21 Dec 2006 20:40:00 +0100 User-Agent: KMail/1.8.2 References: <003a01c7250c$821be550$0d01a8c0@pcsistemas> In-Reply-To: <003a01c7250c$821be550$0d01a8c0@pcsistemas> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200612212040.00735.rossacher@bluewin.ch> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200612/290 X-Sequence-Number: 24082 There is an encoding which is used inside the server. Then the client can specify what encoding the strings are he is sending. The server then transforms the clientencoding to the internal representation. When the described problem occurs this means that something in this process is not set or wrong set. In the documentation you can find a list with supported encodings and conversions in chapter 20 of the manual. For me it did work best to take UTF8 as server encoding and specify the correct client encoding within the initialisation of the database connection (if required at all since most clients are UTF8 anyway). If you need to fix the data already in the database you might use recode or iconv on a text backup dump and restore the result. Best regards Ivo Rossacher Am Donnerstag, 21. Dezember 2006 15.30 schrieb Sistemas C.M.P.: > I'm using Linux server with postgres 8.0.2 and windows clients with VB > aplications that using pgOleDB.dll and Libpq.dll. The problem is: > Some user updates a record (with Text type field) with '?' character in > this field Then, when someone select this record the '?' characters appears > like '$1' This only happen with a few users. Not all > Thanks.