Postgres Pro
Downloads
Home   >   mailing lists

Re: PG export/import encoding issue - Mailing list pgsql-admin

From Jens Wilke
Subject Re: PG export/import encoding issue
Date
Msg-id 201112201806.06766.jens.wilke@affinitas.de
Whole thread Raw
In response to PG export/import encoding issue  ("Scott Toland" <ccitt@thechillhacker.com>)
List pgsql-admin
Tree view 
On Monday 19 December 2011 17:15:49 Scott Toland wrote:

> the problem is the old schema was
> an ASCII neutral zone, and the new server has the schema set for UTF-8

You have to convert the Dump:
http://blog.endpoint.com/2011/12/sanitizing-supposed-utf-8-data.html

HTH, Jens

pgsql-admin by date:

Previous
From: Alexander Fortin
Date:
Subject: Can't get pg_upgrade work for 8.4
Next
From: "Liu, Jianli (Jianli)"
Date:
Subject: Re: User password encryption using a stronger hashing function?