How do I tell if data is in Unicode format or regular character set???

All,

We are on Oracle 9i, and will be looking at performing the Unicode coversion to our DTA and CTL schemas. However, we have other applications (such as CRM) and the admins are unsure whether or not the data in those applications is in Unicode format or in Regular Characterset format. Is there an easy way to tell whether or not data is being stored in a schema is in Unicode format?

Thanks,

Yes. Look at the following (abbreviated) table descriptions for pristdta.f4111 and devdta.f4111. You'll notice the Unicode table (prisdta) has NCHAR column types instead of CHAR. If I'm not mistaken, where VARCHAR exists it becomes NVARCHAR.

SQL> desc pristdta.f4111
Name Null? Type
----------------------------------------- -------- ----------------------------
ILNLIN NUMBER
ILITM NUMBER
ILLITM NCHAR

SQL> desc devdta.f4111
Name Null? Type
----------------------------------------- -------- ----------------------------
ILNLIN NUMBER
ILITM NUMBER
ILLITM CHAR(25)