SQL> create database 'a.fdb';
SQL> CREATE TABLE STRS (
CON>     FLD1  VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI,
CON>     FLD2  VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
CON> )
CON> ;
SQL>
SQL> show table strs;
FLD1                            VARCHAR(10) CHARACTER SET UTF8 Nullable
                                 COLLATE UNICODE_CI
FLD2                            VARCHAR(10) CHARACTER SET UTF8 Nullable
SQL> set sqlda_display;
SQL> select * from strs;

INPUT message field count: 0

OUTPUT message field count: 2
01: sqltype: 448 VARYING Nullable scale: 0 subtype: 0 len: 40 charset: 772 UTF8
  :  name: FLD1  alias: FLD1
  : table: STRS  owner: SYSDBA
02: sqltype: 448 VARYING Nullable scale: 0 subtype: 0 len: 40 charset: 4 UTF8
  :  name: FLD2  alias: FLD2
  : table: STRS  owner: SYSDBA
SQL>