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".

Taidot: SQL

Tietoa asiakkaasta:
( 4 arvostelua ) Warszawa, Poland

Projektin tunnus: #33727837

2 freelanceria on tarjonnut keskimäärin $38 tähän työhön


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 7 päivässä
(4 arvostelua)

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 7 päivässä
(0 arvostelua)