The CONVERT function converts a character string to the specified character set. You cannot specify the source character set as you can with Oracle. The destination character set must be a character set supported by Oracle Rdb. The CONVERT function is functionally equivalent to the TRANSLATE...USING function. Example: Using the CONVERT function SQL> SELECT CONVERT (english, RDB$SHIFT_JIS) cont> FROM colours; Black White Blue Red Yellow Green 6 rows selected