Re: Unicode or local language

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

In response to

Browse pgsql-hackers by date

  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.