- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- At Wits End Configuring NLS for Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-26-2002 10:31 AM
тАО07-26-2002 10:31 AM
Here's my problems.
1 Characters do not get displayed properly using sqlplus or svrmgrl on the server. Using select chr(153) does not return the trademark ??? symbol.
2 The only application that successfully displays the characters is the Oracle 8 SQLPlus Worksheet.
3 Characters are not displayed properly on the Oracle 7 versions of sqlplus and worksheet. The worksheet, however, will properly display the copyright and registered ssymbols.
What in the heck am I doing wrong? I've set the NLS_LANG variable in both UNIX and Windows.
jack...
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-28-2002 11:41 PM
тАО07-28-2002 11:41 PM
Re: At Wits End Configuring NLS for Oracle
The trick here is having the client side configured with the same character set as the server (WE8ISO8859P1).
Since this works on your SQL*Worksheet my guess is that you have several ORACLE_HOMES on your client machine (Windows) and that SQL*PLus uses a different OH than the worksheet.
If SQL*Worksheet is installed as part of the Enterprice Manager it might very well have ended up in a different ORACLE_HOME.
Run REGEDIT and check the settings.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2002 12:05 AM
тАО07-29-2002 12:05 AM
Re: At Wits End Configuring NLS for Oracle
I did some queries on Metalink.
Again, you should check your environment settings.
Also, check the precedence issue:
...
19. Which NLS parameters take precedence?
The default values for LANGUAGE, TERRITORY and derived parameters such as NLS_CURRENCY and NLS_DATE_FORMAT are set to the American defaults when the database is created. These can be overridden for the database at instance level by setting them in init
The client products take their defaults from NLS_LANG (which defaults to AMERICAN_AMERICA.US7ASCII if not set). Individual parameters can be set to override the derived defaults eg: NLS_DATE_FORMAT, NLS_CALENDAR.
Setting these parameters causes an alter session command to be issued when the user logs in. An explicit alter session command , eg:
alter session set nls_sort=german
will override such parameter settings. NLS_LANG must be set for the individual parameters to be accepted.
20. How can I issue alter session commands to change my NLS parameter settings in an application?
Use the database procedure,dbms_session.set_nls(), which takes the name of the parameter plus its value, eg:
dbms_session.set_nls('nls_date_format','''dd/mm/yyyy''');
Note the single quotes - the value must be exactly as it would be typed in an alter session command, eg:
alter session set nls_date_format = 'dd/mm/yyyy';
....
...
From: Oracle, SAMRAT SEN 31-Aug-00 06:14
Subject: Re : insert special symbols through shortcut keys into text field
Hi Srini,
You can insert special characters like (??,??? etc.) into forms' text fields.
Go to windows Start->Programs->Accessories->Character Map,the Unicode Character Map window will open.
You can get the key strokes required for the special character you need by selecting the font you are using in your form from the dropdown list provided in the window.
For example,for the Times New Roman font the key strokes required for the ?? symbol are:Alt+0174.
Thanks and regards.
Samrat Sen
Oracle Support Services
See also, the attached document which deals with a similar issue -- EURO characters.
Hope this helps!
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2002 03:34 AM
тАО07-29-2002 03:34 AM
SolutionThe forum has a new feature that allows you to view any past QUESTIONS you have posted, which allows you to find replies that you haven't acknowledged.
This member has assigned points to 155 of 226 responses to his/her questions.
http://forums.itrc.hp.com/cm/TopSolutions/1,,CA333920!1!questions,00.html
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2002 05:52 AM
тАО07-29-2002 05:52 AM
Re: At Wits End Configuring NLS for Oracle
Thanks for the document on chcp. I tried running chcp 1252 and then ran the applications, but still no luck.
I'm going to change the character set on my workstation to AMERICAN_AMERICA.WE8MSWIN1252 and see if I have any help.
I can cut and paste the output from the Windows client to winword and the symbol is displayed.
The royal mess will be figuring out how to display the trademark on the HP. We want to be able to print and view the symbols using MOTIF applications.
I'm a little smarter. Thanks for the help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2002 06:15 AM
тАО07-29-2002 06:15 AM
Re: At Wits End Configuring NLS for Oracle
It would be nice, maybe I missed it, if we could go to a listing where points have not been assigned or where the question is awaiting response from the originator.
jack...