Unicode or local language

2017-11-20 Thread Lelisa Diriba
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 chara

Ethiopian calendar year(DATE TYPE) are different from the Gregorian calendar year

2017-12-25 Thread Lelisa Diriba
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

Ethiopian calendar year(DATE TYPE) are different from the Gregorian calendar year

2017-12-26 Thread Lelisa Diriba
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 Postgre