I'd try with dump(mycol, 1016) , this will tell you teh character set as well as hex dump of contents if successful. -- //www.freelists.org/webpage/oracle-l