Обсуждение: Maintenance database SQL_ASCII

After a new pgsql installation the "postgres" maintenance database has
an encoding of SQL_ASCII. pgAdmin III gave me a warning about that, and
I may want to create users or databases that are not restricted 7bit ASCII.

I was going to backup and recreate this table, but it can't be dropped.
I guess I could backup all of the other databases and start over from
"initdb", but that would be a hassle. Do I have any other options? The
strange thing is that I have two very similarly configured Ubuntu
machines and the other created the "postgres" database with UTF8 encoding.

The locale on both machines is the same:

$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=


-Brad

On Jun 13, 2009, at 1:52 AM, Brad Schick wrote:

> After a new pgsql installation the "postgres" maintenance database has
> an encoding of SQL_ASCII. pgAdmin III gave me a warning about that,
> and
> I may want to create users or databases that are not restricted 7bit
> ASCII.


SQL_ASCII <> 7 bit ASCII.

What SQL_ASCII does is accept any value, regardless of encoding. It
basically just stores the bytes, even for multi-byte encodings.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4a33842e759156622419335!