On Mar 13, 2006, at 9:24 PM, CSN wrote:
> I'm updating a field via a web form, and an em-dash is
> getting stored in the database as 'âÂ-', and is
> getting displayed back on the web page as '— '. The
> encoding of the database is SQL_ASCII - should I
> change it? And if so, to what and how?
Yes, you should change it. None of the non-ASCII characters are going
to be properly encoded in the database. What you should change it to
depends the software you are using to process the form. You need to
make sure the client_encoding setting of your connection matches what
you are working with on the form.
Normally you could change the database encoding by dumping and then
reloading the database. But you'll likely have problems because your
SQL_ASCII encoded database has illegal characters that won't be
accepted if you change to something like UTF-8. A utility like iconv
might help with this.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL