Postgres Pro
Downloads
Home   >   mailing lists

Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db? - Mailing list pgsql-general

From skmanji
Subject Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db?
Date
Msg-id 1318145956192-4884598.post@n5.nabble.com
Whole thread Raw
In response to Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db?  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
List pgsql-general
Tree view
You can do this by converting the characters in raw dump file directly. iconv -f 8859_1 -t UTF-8 backup.db.psql > backup.db.psql.utf8 Then convert the line in backup.db.psql.utf8 from: SET client_encoding = 'SQL_ASCII'; to: SET client_encoding = 'UTF8';
View this message in context: Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db?
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to add xml data to table
Next
From: "Andrus"
Date:
Subject: Re: How to add xml data to table