Sample Header Ad - 728x90

PostgreSQL translate special characters?

2 votes
1 answer
3445 views
**Description:** PostgreSQL 9.3 String: **'ì ằ ú ề'** Desired Result: **'i a u e'** My code: select translate ('ì ằ ú ề', 'ìằúề', 'iaue') ; -- it works. Result: i a u e **Question:** If I use it this way, I have to define a manual translation between 'ìằúề' and 'iaue'. Is there a better solution? Ref: PG Document
Asked by Luan Huynh (2010 rep)
Dec 28, 2015, 10:57 AM
Last activity: Dec 29, 2015, 04:19 AM