Re: Maintenance database SQL_ASCII

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Brad Schick <schickb(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Maintenance database SQL_ASCII
Date: 2009-06-13 10:49:16
Message-ID: 63E44939-7CC1-4B5B-BA72-050CB00A61FF@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2009-06-13 11:09:19 Re: How to store text files in the postgresql?
Previous Message Alban Hertroys 2009-06-13 10:45:12 Re: String Manipulation