On Mar 16, 2006, at 14:42 , mike wrote:
If you don't care to store those characters then maybe you should
change
the database character set to use SQL_ASCII instead of UTF-8. I
believe
ASCII will quietly discard those characters when converting from
UTF-8.
SQL_ASCII is *not* ASCII. See the "What's a good default encoding?"
thread on this same list from today.
http://archives.postgresql.org/pgsql-general/2006-03/msg00685.php
I don't believe it will discard anything on import if the database is
SQL_ASCII encoded.
Michael Glaesemann
grzm myrealbox com