| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | jvm(at)gopinocchio(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Default encoding in database |
| Date: | 2001-08-30 00:58:04 |
| Message-ID: | 20010830095804A.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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 --enable-unicode-conversion
I guess you have multibyte disabled or not configured as
"--enable-multibyte=LATIN1" another PostgreSQL somewhere.
Or you have done initdb with such PostgreSQL.
How does the output from "psql -l" look like?
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Udkow | 2001-08-30 02:21:25 | ERROR: Function 'format_type(oid, int4)' does not exist |
| Previous Message | Colin Campbell | 2001-08-30 00:40:48 | Re: ERROR: int8 conversion to int4 is out of range |