RE: [GENERAL] Default encoding in database

2001-08-30 Thread Tatsuo Ishii
> > How does the output from "psql -l" look like? > List of databases > Database | Owner | Encoding > +--+--- > template0 | postgres | SQL_ASCII > template1 | postgres | SQL_ASCII > Jacob I don't know why your template1 DB's encoding is SQL_ASCII, bu

[GENERAL] Default encoding in database

2001-08-29 Thread Jacob Vennervald Madsen
Hi List I'm using PostgreSQL version PostgreSQL 7.1.2 When I create a new database it's made with SQL_ASCII by default. What do I have to do to make LATIN1 the default encoding? This is how I configured Postgres ./configure --with-java --enable-odbc --enable-multibyte=LATIN1 --enable-locale --ena