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!
Is your database in UTF8 format?
If yes, then you have to set session variables (NLS Parameters) based on the User. You can also write a database trigger ON SESSION LOGON in which you specify the NLS parameters for that user.
Hope this helps you...