<html><div style='background-color:'><DIV class=RTE>
<P>I update manually the perl script to add the charset parameter.</P>
<P>And yes I already have the dump file ;-p<BR><BR></P><BR><BR><BR>>From: strk@refractions.net<BR>>Reply-To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>>To: postgis-users@postgis.refractions.net<BR>>Subject: Re: [postgis-users] postgis_restore.pl lost charset information<BR>>Date: Thu, 26 May 2005 22:25:12 +0200<BR>><BR>> >From 1.0.1 CHANGES file:<BR>><BR>> - NEW support for custom createdb options in postgis_restore.pl<BR>><BR>>Basically you pass createdb option last.<BR>>A no-args invocation of it shows usage.<BR>>I hope you still have your dump around.<BR>><BR>>--strk;<BR>><BR>>On Thu, May 26, 2005 at 12:05:47PM +0200, Xavier Vanderstukken wrote:<BR>> > My original database was in latin1 encoding.<BR>> ><BR>> > I follow the procedure to
dump and then restore the data in Postgis 1.0.0.<BR>> ><BR>> > (postgis_restore.pl lwpostgis.sql roads roads.dump)<BR>> ><BR>> > But the created database is in SQL_ASCII charset and I receive error in my<BR>> > application using jdbc to retrieve data :<BR>> ><BR>> > org.postgresql.util.PSQLException: Invalid character data was found. This<BR>> > is most likely caused by stored data containing characters that are invalid<BR>> > for the character set the database was created in. The most common example<BR>> > of this is storing 8bit data in a SQL_ASCII database.<BR>> ><BR>> > How can I change the charset of the created database before the import<BR>> > procedure?<BR>> ><BR>> > _________________________________________________________________<BR>> ><BR>> ><BR>> >
_______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>>_______________________________________________<BR>>postgis-users mailing list<BR>>postgis-users@postgis.refractions.net<BR>>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></DIV></div><br clear=all><hr> </html>