Hi All, I appreciate if some one could help me on this. I have requirement to cleanup special character of field. So Here HÃ-re - I need value Hire(actual value) from the field. Ã- this has written into file instead of i In database following values are there NLS_NCHAR_CHARACTERSET - AL16UTF16 NLS_CHARACTERSET - UTF8 I tried below to achieve complete solution rather than using translate/replace. but not able to(its returning " ?? "). select convert('HÃ-re','UTF8') from dual --------------- Output: H??re Can any one please provide me a solution. Thanks, raman.