In our database we need to save email templates which comes in different languages. So based on user's preferenece, the email template of that user's choice will be used.

Since we need to save many different languages in the db at the same time, do I need to set codepage etc to make this work? OR all I only need to define the string columns as NVARCHAR2?

Your input is greatly appreciated!