| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
| Cc: | jvm(at)gopinocchio(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Default encoding in database |
| Date: | 2001-08-30 09:02:54 |
| Message-ID: | 20010830110254.A15618@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 30, 2001 at 05:28:16PM +0900, Tatsuo Ishii wrote:
> > > 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, but you
> need to change the encoding of the DB anyway.
>
> try:
>
> psql -c "update pg_database set encoding = 7 where datname =
> 'template1'" template1
IMHO more careful is re-build it by initdb with option -E LATIN1.
KArel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacob Vennervald Madsen | 2001-08-30 09:04:39 | RE: Default encoding in database |
| Previous Message | Christian MEUNIER | 2001-08-30 08:54:45 | Too many open files in system FATAL2 |