<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre wrap="">Gustavo,
That works so much better. Thanks for correcting me...I wish I had known this over a year ago, because even with my approach to the problem sometimes some characters were not converted properly (which I forgot to mention), even though they were 'allowed' as SQL_ACII.
</pre>
Mike<br>
<br>
<br>
Gustavo Henrique Sberze Ribas wrote:
<blockquote
cite="midE6F2049DCBE10840B22DC64587E6F3EC0DAEDF@MAILSRV1.aquarius.cpqd.com.br"
type="cite">
<pre wrap=""> Tom,
try setting the client encoding to LATIN1, put
"SET client_encoding = 'LATIN1';" on the first line of
the file created with shp2pgsql.
As for SQL_ASCII, I advise against it. SQL_ASCII is for 7-bit
text data only, if you need to store text in French,Italian,
Portuguese,Spanish,... use LATIN1 instead (or UNICODE).
With SQL_ASCII there is no restriction on what data can be entered
and you can get yourself in a real mess with different clients entering
data in different encodings.
--
Gustavo
</pre>
<blockquote type="cite">
<pre wrap="">I had the same problem a while ago, and found that if my
database is set
to SQL_ASCII it would work fine...though I think you can only set the
encoding when the database is created. I tried using some
text editors
to convert the characters in the script created by the shp2pgsql tool,
but that didn't work. I was able to use find/replace to
change special
characters (in Spanish) to unicode-compatible characters,
which sort-of
worked, but I didn't really want to get rid of those characters. I
found it was just easier to create my database in SQL_ASCII from the
start. Perhaps somebody else has a more effective solution...
Mike
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>