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
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 |