If you missed the latest new: Datamodeler is now FREE (as in “gratis”).
Go get the tools!
Read more about it on Kris Rice Blog
Recently i was dealing with a translation problem regarding multibyte characters (cyrillic). They were stored in a NCLOB and were later on moved to a VARCHAR2.
Before moving the data i had to ensure, that there will be enough space in the VARCHAR2 columns which were defined as VARCHAR2(255 BYTE).