DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001

    Save multiple languages in db

    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!

  2. #2
    Join Date
    Feb 2002
    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...


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.