Database encoding and collation - Mailing list pgsql-admin

From Rodrigo Barboza
Subject Database encoding and collation
Date
Msg-id CANs8QJY8vnHXBp4dGO0NW2k5SyLkw+8wERL80q7ZEfj1rz7kog@mail.gmail.com
Whole thread Raw
Responses Re: Database encoding and collation  (Craig James <cjames@emolecules.com>)
List 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?


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pb migrating database from Postgres 8.1 to 8.4
Next
From: Craig James
Date:
Subject: Re: Database encoding and collation