Unicode or local language

Started by Lelisa Diribaabout 8 years ago2 messages
#1Lelisa Diriba
lelisa0404@gmail.com

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?

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Lelisa Diriba (#1)
Re: Unicode or local language

Lelisa Diriba wrote:

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?

It's a bit hard to tell what is going on since you don't say what
your database encoding is, but I *guess* that everything is
working fine, except that your terminal does not expect unicode
and displays each character as three bytes.

What do you get if you run

SELECT name::bytea FROM person;

Yours,
Laurenz Albe