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