How do the applications handle special characters and non-English characters?

Any character you enter into an Oracle application is stored in unicode.