Re: [ADMIN] PG export/import encoding issue

2011-12-20 Thread Jens Wilke
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 -- Sent via

[ADMIN] PG export/import encoding issue

2011-12-19 Thread Scott Toland
Hi guys I have a 8.4 install that I am moving to a new DB server running 9.0. This is all well and god for the most part, except when it comes to restoring the data in several of the tables. See the problem is the old schema was an ASCII neutral zone, and the new server has the schema set for