Convert – Oracle SQL Function

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

Syntax:

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.

Example:

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

RESULT
—————
go to UTF8 from ascii