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'tthe 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
