From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Lelisa Diriba <lelisa0404(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Unicode or local language |
Date: | 2017-11-20 12:51:19 |
Message-ID: | 1511182279.2615.17.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Fabrízio de Royes Mello | 2017-11-20 12:55:18 | Re: [HACKERS] [PATCH] A hook for session start |
Previous Message | amul sul | 2017-11-20 12:46:51 | Re: [COMMITTERS] pgsql: Add hash partitioning. |