DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Save multiple languages in db

  1. #1
    Join Date
    May 2001
    Posts
    285

    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
    Posts
    70
    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...

    Thanks,
    ________________
    ShanDJ

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