Database encoding and collation

From: Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database encoding and collation
Date: 2013-04-20 00:12:59
Message-ID: CANs8QJY8vnHXBp4dGO0NW2k5SyLkw+8wERL80q7ZEfj1rz7kog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi guys.
I created a database with default encoding (SQL_ASCII) and default collate
(C).
I created a table test like this:
create table test (a varchar (10));
Then i executed "insert into teste (a) values ('áéç&ã','Æ','ß');

After that:
select * from test;
a
---------
áéç&ã
Æ
ß

Why did it stora correctly if those values are not ASCII?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2013-04-20 16:52:55 Re: Database encoding and collation
Previous Message Tom Lane 2013-04-19 16:09:40 Re: Pb migrating database from Postgres 8.1 to 8.4