On 8/29/08, Andrew Sullivan <ajs(at)commandprompt(dot)com> wrote:
> The latter should be in effect if your database encoding is UTF-8.
> What's the database encoding?
My database encoding on BOTH the sides is UTF8. The dumped DB is UTF8.
The one I am importing into is also UTF8. So why is it showing me this
error? Do I also have to look at stuff like "collation"?
Also, how can I ensure that my dumped database on the server has only
UTF8 data? What constraint or function can I use?
In response to
pgsql-admin by date
|Next:||From: Vishal Arora||Date: 2008-08-29 10:12:53|
|Subject: Re: psql data restore not working|
|Previous:||From: Daniel Punton||Date: 2008-08-29 00:26:44|
|Subject: psql data restore not working|
pgsql-general by date
|Next:||From: Giorgio Valoti||Date: 2008-08-29 06:39:54|
|Subject: [Semi-OT]: How to customize locales?|
|Previous:||From: Tom Lane||Date: 2008-08-29 04:45:20|
|Subject: Re: MySQL LAST_INSERT_ID() to Postgres |