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