to_nchar (character) converts a character string, CLOB, or NCLOB from the database character set to the national character set. This function is equivalent to the translate function with a USING clause in the national character set.