CONVERT converts the string argument from one character set to another one.


CONVERT(string,destination_set, source_set)

The source_set argument specifies the character set of the stored data in the database if ‘string’ is a column name, or the character set of ‘string’ if it is an argument to the function.

‘Destination_set’ is the character set you want to convert to.


SELECT CONVERT(‘go to UTF8 from ascii’,’UTF8′,’US7ASCII’) as RESULT from DUAL;

go to UTF8 from ascii

Convert – Oracle SQL Function
Tagged on: