Unicode or local language
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?
Ethiopian calendar year(DATE TYPE) are different from the Gregorian calendar year
In Ethiopia the year have 13 months and but in Gregorian calendar the year have 12 months, The Ethiopian society's are want to use his Ethiopian calendar year,i have the algorithm, but the way i add to the postgresql source code as EXTENSION? or to the backend(to kernel)? 13th month have 5 days and in fourth year 13th month have 6 days.that means 1 year have 365.25 days,my algorithm converts Gregorian calendar year to Ethiopian calendar year.
Ethiopian calendar year(DATE TYPE) are different from the Gregorian calendar year
yes it works on my machine,it coverts from Gregorian calendar year to Ethiopian calendar year. Swift ,C# & Java languages locally we have app to convert it, but i can't get it from them,it is as a commercial,Also ORACLE DB localize it.Oracle DB also use for commercial, I want to Localize in PostgreSQL.it works as an EXTENSION, how it be localized to Postgresql?
