Converting CP1252 to UTF-8

From: Robert D Oden <roden(at)dbasetek(dot)com>
To: PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Converting CP1252 to UTF-8
Date: 2006-11-24 05:39:24
Message-ID: 4566858C.6010406@dbasetek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a total of 60GB's in several database with encoding set to
SQL_ASCII. I am using version 8.0. The data has always been encoded in
CP1252 prior to inserting into the database.

I have characters between 0x80 and 0x9F scattered throughout the
databases which I cannot loose.

I noticed in version 8.1 I can set the database encoding to WIN1252.
Will the following work to keep from loosing the above characters:

Upgrade to 8.1
Create the databases in CP1252
Restore the data
Dump the databases again to set the appropriate encoding in the dump file
Create the databases with UTF-8 encoding
Restore the data

Thanks in advance,

Doug

--

Robert D Oden
Database Marketing Technologies, Inc
951 Locust Hill Circle
Belton MO 64012-1786

Ph: 816-318-8840
Fax: 816-318-8841

roden(at)dbasetek(dot)com

Browse pgsql-admin by date

  From Date Subject
Next Message Marcelo Costa 2006-11-24 17:45:10 Function ERRO after UPGRADE from 7.4 to 8.1.5
Previous Message Bruce Momjian 2006-11-23 03:31:00 Re: Archive WAL Logs Failed