Re: Database encoding and collation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Fri, Apr 19, 2013 at 5:12 PM, Rodrigo Barboza <rodrigombufrj@xxxxxxxxx> wrote:
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?

Characters are interpreted and displayed by your terminal, not the Postgres system.  I suspect that you have language settings on whatever windowing system you use.  Postgres merely interprets the characters you send as a series of 8-bit bytes.  It's up to your display system to interpret them.  If you change your display terminal's language, I expect you'll see something different.

The language settings of Postgres don't change what is stored, only how it is interpreted (such as sorting).

Craig


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux