Re: Database encoding and collation

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: Database encoding and collation
Дата
Msg-id CAFwQ8rdmUSFkXRR9Jpo7Fk89pi+dp4GA3B4cUpNPGTjVoQCzXQ@mail.gmail.com
обсуждение исходный текст
Ответ на Database encoding and collation  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Ответы Re: Database encoding and collation  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Список pgsql-admin

On Fri, Apr 19, 2013 at 5:12 PM, Rodrigo Barboza <rodrigombufrj@gmail.com> 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rodrigo Barboza
Дата:
Сообщение: Database encoding and collation
Следующее
От: Rodrigo Barboza
Дата:
Сообщение: Re: Database encoding and collation