When I create a view with hard-coded fixed length text, Oracle automatically views it as CHAR datatype. The only way to change it to VARCHAR2 is explicitly CAST it. Is that assumption true? Is there a database level setting that will always use VARCHAR2 for all text instead?