Unicode or local language - Mailing list pgsql-hackers

From Lelisa Diriba
Subject Unicode or local language
Date
Msg-id CAM7dW9gX_J4PHmKVZHrwwNvo_AOEEubJ+oS66O+Mr44sXzTc4g@mail.gmail.com
Whole thread Raw
Responses Re: Unicode or local language  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
unicode=# SET CLIENT_ENCODING TO UNICODE;
SET
unicode=# show client_encoding;
 client_encoding
-----------------
 UTF8
(1 row)
insert into person(name) values('ሳምሶን');when i insert From PGAdmin and when i want to SELECT FROM  SQL SHELL(PSQL) i doesn't the normal value.how psql support UNICODE character?
unicode=# select * from person;( from SQL SHELL)
 ßê│ßê¥ßê╢ßèò
(1 rows)
select * from person;(from PGAdmin)
ሳምሶን
(1 rows)
The Language i use is "Amharic language" which is From Africa (Ethiopia country)
I want use the local language Amharic from  SQL SHELL,
How i use the Local Language  from SQL SHELL?

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] CUBE seems a bit confused about ORDER BY
Next
From: amul sul
Date:
Subject: Re: [COMMITTERS] pgsql: Add hash partitioning.