X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 40CE6D1EFB3 for ; Mon, 3 May 2004 16:24:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 05714-02 for ; Mon, 3 May 2004 16:24:38 -0300 (ADT) Received: from mail.acadaca.com (mail18.datapipe.com [64.27.65.37]) by svr1.postgresql.org (Postfix) with ESMTP id 129C8D1EEE6 for ; Mon, 3 May 2004 16:24:32 -0300 (ADT) Received: from Pedro [66.9.138.34] by mail.acadaca.com with ESMTP (SMTPD32-8.05) id AC72255C0084; Mon, 03 May 2004 15:24:34 -0400 From: "Noah Davis" To: Subject: Bad character data Date: Mon, 3 May 2004 15:23:40 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcQxPyuJ0frzF3YlSmyFzWnTaLT2hQABN6DA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 In-Reply-To: Message-Id: <200405031524353.SM01356@Pedro> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/9 X-Sequence-Number: 13325 I posted this to the pgsql general list, but alas, I did not get any responses. Perhaps someone here could be of assistance? I have a database with some bad characters in it -- some users had entered MS Word smart quotes, em dashes, foreign characters, and they look like gibberish coming out of the database. Most important are the smart quotes I guess. What's the best way to replace these characters? I thought I might be able to run a simple SQL UPDATE command, but some of the gibberish for different characters looks the same (at least from my client it does), and it would clobber them all. I have a feeling there's some sort of ASCII code or unicode solution to this problem, but I could use am little push in the right direction. Thanks. Noah.