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 1D814D1B4BE for ; Mon, 19 Apr 2004 16:44:40 -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 76101-06 for ; Mon, 19 Apr 2004 16:44:38 -0300 (ADT) Received: from server1070.gisol.com (server1070.gisol.com [216.240.136.190]) by svr1.postgresql.org (Postfix) with ESMTP id 27989D1DACB for ; Mon, 19 Apr 2004 16:44:36 -0300 (ADT) Received: from h0080c8146f54.ne.client2.attbi.com ([24.128.49.92] helo=crumpet) by server1070.gisol.com with esmtp (Exim 4.24) id 1BFegz-00035r-2w; Mon, 19 Apr 2004 12:44:33 -0700 From: "Dion Almaer" To: Cc: "'Lloyd Benson'" , "Eric Preston" Subject: Going from a DB using SQL_ASCII to UNICODE Date: Mon, 19 Apr 2004 15:44:33 -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: AcQmRrzqDTqwKBDfTCSZ3c3NpKjqPQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-Id: X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server1070.gisol.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - almaer.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/252 X-Sequence-Number: 13225 Hi - We are running PostgreSQL 7.1.4, and are finally upgrading... to 7.4.2. While we do this upgrade, we also want to make create our DB as UNICODE (we are having problems with SQL_ASCII where we get a bunch of ? marks). When we try to import the data from a SQL_ASCII dumped db, into the new UNICODE db, everything freaks out. We get errors restoring from dumps that used COPY and with INSERT. We also tried to use the 7.4 pg_dump to make sure that it wasn't a problem with the old pg_dump. The errors are: - ERROR: missing data for column "noiselevel" - CONTEXT: COPY messages, line 1: "4393 -1 1441 14147 0 2000-10-12 18:30:58-05 EJB Design Questions \N Hi," - FATAL: invalid frontend message type 60 - ERROR: invalid byte sequence for encoding "UNICODE": 0xe9616c Anyway, if anyone has any recommendations on how to migrate from SQL_ASCII to UNICODE, with the knowledge that we are going from 7.1 to 7.4 at the same time.... You will be life-savers! Cheers, Dion