Replace some special characters in Teradata

Database
Enthusiast

Replace some special characters in Teradata

How to replace those characters in teradata.

From     To

Φ          è

Θ         é

╔         É

╛        ¾

√        û

1 REPLY
Junior Contributor

Re: Replace some special characters in Teradata

oTranslate(col, 'ΦΘ╔╛√', 'èéɾû')

Did you load wrong data or using a wrong character set?