Đã Đóng

Postgres - new field in table with ASCII chars

I need script for postgres database. I have table COUNTRIES with NAME field containing string - country name. The name of country is given in national language . For example Greece is Ελλάδα, Georgia is საქართველო, or Ukraine Україна. I need to convert national chars into ASCII, with transliteration. The perfect example is here: [login to view URL] I don't need convert particular string as in given example, but I need make "ALTER TABLE COUNTRIES ADD NAME_ASCII" and fill it with transliterated values. For example if NAME filed has '鍖椾喊' value, in NAME_ASCII will appear "Chen Zhan Han".

Kĩ năng: SQL

Về khách hàng:
( 4 nhận xét ) Warszawa, Poland

ID dự án: #33727837

2 freelancer chào giá trung bình$38 cho công việc này

eagleeyesvw

Hi, I will do the required column in postres as required. I am an experienced postgresql developer with alot of working experience. Plz discuss in case of confusion. Regards, Eagle Eyes

$55 USD trong 7 ngày
(4 Nhận xét)
1.7
ScalaAndPostgres

From the looks of it, all we need to do is install the transliteration library that you have linked into your database. If you want, I can walk you through that on a call with screen sharing.

$20 USD trong 7 ngày
(0 Nhận xét)
0.0