Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9862A9FBD9C for ; Tue, 7 Aug 2007 18:09:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 12570-08 for ; Tue, 7 Aug 2007 18:09:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 9FC429FB648 for ; Tue, 7 Aug 2007 18:09:37 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so149574ugf for ; Tue, 07 Aug 2007 14:09:36 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=JAoNGWCYmDMU+zyY+mJ7J1yJ8nj/1B5gT0O3PEy6brDDEj2rA9fAgehz4ZlxzD/F0llB4x0g/3Uvsgm37kpI3py0MVs6t/QqY2rnNczJ9roKGN9SwoTVfPC7nSAzx4OLx1/OWD1O0Ra3Lcj7fJtlgxIkw9gKlOwAuAIONYrhyAQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=cSMN3njpNGi4Irp/x2ApQNgpfd89KhBniImW+bu8CUUwsyQCYYYMw3pUVZ8/d/f/lpt5nrKVo8RMHiAugQqd14+KJITx9CfiZ1bEQuurJIRPeyGJyS/QwnvKa37x3mtRI1nzDCY6PV282p62jokAguB/mJsTSaprZhRkPFL8CqQ= Received: by 10.78.201.2 with SMTP id y2mr1955187huf.1186520975892; Tue, 07 Aug 2007 14:09:35 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Tue, 7 Aug 2007 14:09:35 -0700 (PDT) Message-ID: <1d219a6f0708071409s1f66c0f1u9ff69bc3cc580bcf@mail.gmail.com> Date: Tue, 7 Aug 2007 17:09:35 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: Help with High value unicode characters MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_126472_7119108.1186520975854" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/54 X-Sequence-Number: 26385 ------=_Part_126472_7119108.1186520975854 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline We need some help, we have some what we believe are high value unicode characters (Unicode 0x2). How can you search and replace for these? We are storing this data in a text field, and having the data contain this unicode value is violating our xml rules the application uses and causing abends in our application. Obviously our developers will have to fix this in the application, but how do we fix it in our database. We are needed to clean up the existing data so our customers can view the data that has been imported up to this point. Thanks for any advice, Chris ------=_Part_126472_7119108.1186520975854 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline We need some help, we have some what we believe are high value unicode characters (Unicode 0x2).  How can you search and replace for these?  We are storing this data in a text field, and having the data contain this unicode value is violating our xml rules the application uses and causing abends in our application.

 Obviously our developers will have to fix this in the application, but how do we fix it in our database.  We are needed to clean up the existing data so our customers can view the data that has been imported up to this point.

Thanks for any advice,

Chris
------=_Part_126472_7119108.1186520975854--