[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] postgis_restore.pl lost charset information
From: "Xavier Vanderstukken" <xavan18 () hotmail ! com>
Date: 2005-05-27 5:22:37
Message-ID: BAY21-F89940445B01B8E2D68E5CA6000 () phx ! gbl
[Download RAW message or body]
<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>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic