Forum OpenACS Q&A: Response to howto run 3.2.5 with European characters on nsd8x

Collapse
17: Response to howto run 3.2.5 with European characters on nsd8x (response to 1)
Posted by David Kuczek on 03/05/02 04:32 PM
Marcin,

I just created a db with "createdb -E latin1" and imported my old (sql-ascii) database...

As I had my /etc/profile set to PGCLIENTENCODING='unicode' I first had to do a:

PGCLIENTENCODING='latin1' ; export PGCLIENTENCODING

before I could import the database. Otherwise errormsg occurred...

When I enter the database via shell psql and don't want to see corrupted special characters I also have to set:

PGCLIENTENCODING='latin1' ; export PGCLIENTENCODING

Does this sound correct and familiar???