[postgis-users] postgis_restore.pl lost charset information

[Xavier Vanderstukken]

My original database was in latin1 encoding.

I follow the procedure to dump and then restore the data in Postgis 1.0.0.

(postgis_restore.pl lwpostgis.sql roads roads.dump)

But the created database is in SQL_ASCII charset and I receive error in my 
application using jdbc to retrieve data :

org.postgresql.util.PSQLException: Invalid character data was found.  This 
is most likely caused by stored data containing characters that are invalid 
for the character set the database was created in.  The most common example 
of this is storing 8bit data in a SQL_ASCII database.

How can I change the charset of the created database before the import 
procedure?

_________________________________________________________________