If you want to get see the unicode codes of a regular varchar2 field on select in your oracle database you need to do this.

select ASCIISTR(name) from entity_table

this will display codes like this:

\30AF\30E9\30C3\30B7\30E5\30FB\30D0\30F3\30C7\30A3\30AF\30FC

instead of this:

クラッシュ・バンディクー ( actually it's a row of blocks in the oracle client )