9ias NLS_LANG problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 9ias NLS_LANG problem

  1. #1
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    The environment is 9iAS on Solaris 2.8 with an 8.1.7 database.

    The database has character set WE8ISO8859P1.

    Umlauts (the two dots above certain vowels), are dropped when using a web application based on the PL/SQL web development kit.

    Oracle Forms with the same userid and the same database doesn't change the data.

    I think it is a client problem, but need a suggestion on how to set the NLS_LANG on a web client.

    Any ideas?
    David Knight
    OCP DBA 8i, 9i, 10g

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    This was solved by setting the NLS_LANG parameter in the startJServ.sh script.

    NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1; export NLS_LANG

    NLS_LANG is therefore set at the web server level and cannot be different for each DAD.

    AMERICAN_AMERICA.WE8ISO8859P1 will work also.



    [Edited by dknight on 04-29-2002 at 09:39 AM]
    David Knight
    OCP DBA 8i, 9i, 10g

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