Default encoding in database
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 --enable-unicode-conversion
Can anybody help me?
Best regards,
Jacob Vennervald Madsen
Mobile Systems Developer
GoPinocchio
Norrebrogade 45
DK-2200 Copenhagen
www.gopinocchio.com
+45 26750106
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
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
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
--
Tatsuo Ishii
Import Notes
Reply to msg id not found: 19514C7E64E4FA4FBEEC9BA3CB3376FD17B682@gopinocchio-sbs.gopinocchio.localReference msg id not found: 19514C7E64E4FA4FBEEC9BA3CB3376FD17B682@gopinocchio-sbs.gopinocchio.local | Resolved by subject fallback
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
JacobI 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@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
If I do rebuild it with initdb will I still have all my data?
Jacob
-----Original Message-----
From: Karel Zak [mailto:zakkr@zf.jcu.cz]
Sent: 30. august 2001 11:03
To: Tatsuo Ishii
Cc: Jacob Vennervald Madsen; pgsql-general@postgresql.org
Subject: Re: Default encoding in database
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
JacobI 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@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
Import Notes
Resolved by subject fallback
On Thu, Aug 30, 2001 at 11:04:39AM +0200, Jacob Vennervald Madsen wrote:
If I do rebuild it with initdb will I still have all my data?
No of course, initdb create everything again... but if you have
only templates DB you probably haven't some data, else you must
dump all your DB and backup it and rebuild templates.
List of databases
Database | Owner | Encoding
------------+----------+-----------
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
Jacob
BTW, I don't understand why you don't create new databases by
CREATE DATABASE bar WITH ENCODING = 'foo' or by "createdb -E".
Karel
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz