Converting nls_lang format
I want to convert the nls_lang from american_america.us7ascii to french_france.utf8. Is this possible?
You can make NLS_LANG anything you wish as it is simply an environment variable.
The following examples show how date and number formats are affected by NLS_LANG.
% setenv NLS_LANG American_America.WE8ISO8859P1
SQL> SELECT ename, hiredate, ROUND(sal/12,2) sal FROM emp;
ENAME | HIREDATE | SAL |
Clark | 09-DEC-88 | 4195.83 |
Miller | 23-MAR-92 | 4366.67 |
Strauß | 01-APR-95 | 3795.87 |
If NLS_LANG is set with the language as French, the territory as France, and the character set as Western European 8-bit ISO 8859-1, the same query returns:
% setenv NLS_LANG French_France.WE8ISO8859P1
SQL> SELECT ename, hiredate, ROUND(sal/12,2) sal FROM emp;
ENAME | HIREDATE | SAL |
Clark | 09/12/88 | 4195,83 |
Miller | 23/03/92 | 4366,67 |
Strauß | 01/04/95 | 3795,87 |
You didn't mention if this is strictly an NLS_LANG setting or a character set issue. If you're wanting to change the characterset of your data that's really another issue. The character set of your database is one thing and the display via NLS_LANG is another.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments